Error while trying to connect bd MSSQL Server using PDO

Question

I cannot access the MS SQL SERVER database using PDO. I’ve done everything, the best answer I could was with the code below, but I keep getting an error reply:

SQLSTATE[] Connection Error (null) (Severity 0)

My server is Centos 5.11 (64 bits)

Any idea?

<?php
  try {
    $hostname = "db-gadel-campinas.lexos.com.br,1500";
    $dbname = "LexManager_GadelCampinas";
    $username = "gadelview";
    $pw = "password";
    $pdo = new PDO ('dblib:host=$hostname;dbname=$dbname', '$username', '$pw');
  } catch (PDOException $e) {
    echo "Erro de Conexão " . $e->getMessage() . "\n";
    exit;
  }
?>

---

I changed the code and it seems to work the connection with sqlserver . Now is to find out how to query the table and show the data :). Any hint?

The code is correct?

<?php
  try {
    $hostname = "db-gadel-campinas.lexos.com.br";
    $port = 1500;
    $dbname = "LexManager_GadelCampinas";
    $username = "gadelview";
    $pw = "password";
    $dbh = new PDO ("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
    echo "Conexão ok";
  } catch (PDOException $e) {
    echo "Failed to get DB handle: " . $e->getMessage() . "\n";
    exit;
}
?>

Answer 1

When it runs the script in windows I believe it uses the comma so (dblib:host=HOST,PORTA):

new PDO('dblib:host=db-gadel-campinas.lexos.com.br,1500;dbname=<banco>', '<usuario>', '<senha>');

If it’s linux (or like-Unix) I think it’s right to use :, thus:

new PDO('dblib:host=db-gadel-campinas.lexos.com.br:1500;dbname=<banco>', '<usuario>', '<senha>');

Out that you used ' apostrophes and tried to pass variables like this '$variavel', php does not recognize this as a variable, it will think it is just a string, i can then concatenate or use normal quotes "

Do it:

$hostname = "db-gadel-campinas.lexos.com.br:1500";
$dbname = "LexManager_GadelCampinas";
$username = "gadelview";
$pw = "password";
$pdo = new PDO ('dblib:host=' . $hostname . ';dbname='. $dbname, $username, $pw);

Or with quotation marks (the other parameters do not need quotation marks)

$hostname = "db-gadel-campinas.lexos.com.br:1500";
$dbname = "LexManager_GadelCampinas";
$username = "gadelview";
$pw = "password";
$pdo = new PDO ("dblib:host=$hostname;dbname=$dbname", $username, $pw);

If the problem is really with the comma, you can do this:

if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
    $hostname = "db-gadel-campinas.lexos.com.br,1500";
} else {
    $hostname = "db-gadel-campinas.lexos.com.br:1500";
}