Do I need a port

Asked Jun 15 '18 at 18:07

Active Jun 15 '18 at 18:07

Viewed 35 times

Im trying to get a webpage to connect to a database on sql server, but the connection keeps failing. I was wondering if my problem is that I need to use a port to help the webpage connect.

<?php

    include 'ConnectionInfo.php';
    try
    {
      $dsn="sqlsrv:Server=$Servername;Database=$Database";
      $pdo = new PDO($dsn,$Username,$Password);
      $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    }
    catch (PDOException $e)
    {

      echo "Connection to database failed: " . $e->getMessage();

    }

    ?>

asked Jun 15 '18 at 18:07

Grant Gahwiler

3

Only if the database is listening on a different port from the default. – Barmar Jun 15 '18 at 18:09
2

What does the error tell you? – MonkeyZeus Jun 15 '18 at 18:16
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo "Connection to database failed: " . $e->getMessage(); } ?> – Grant Gahwiler Jun 15 '18 at 18:29
Yes, it looks like your code prints an error message if the connection fails. What is the error message? – Don't Panic Jun 15 '18 at 18:34
I'm only getting the message from my catch statement. – Grant Gahwiler Jun 15 '18 at 18:37
1

What is the error message?!?! – MonkeyZeus Jun 15 '18 at 18:37
i guess I'm not getting an error message – Grant Gahwiler Jun 15 '18 at 18:43
You mean, you're only seeing "Connection to database failed: " without anything after it? – Don't Panic Jun 15 '18 at 18:45
OH wait, I think I see what's happening. The PHP code isn't being executed. You're seeing the actual PHP code in the browser? – Don't Panic Jun 15 '18 at 18:46
yea I'm noticing it's showing it as an html comment – Grant Gahwiler Jun 15 '18 at 18:49
is there a reason it's not being executed? – Grant Gahwiler Jun 15 '18 at 18:54
That "code shows on the page" Q&A should help get you going. If you have any specific questions about it, you can mention me in a comment (@Don'tPanic) and I'll be happy to try to help. – Don't Panic Jun 15 '18 at 19:36

Do I need a port

0 Answers0