PHP and SQLServer Connection

Question

PHP and SQLServer Connection

Navigation

#1 by (1 votes)
#2 by (0 votes)
#3 by (0 votes)

3

I'm trying to make a connection to SQLServer and PHP But the page returns me the following error:

Warning: mssql_connect () [function.mssql-connect]: Unable to connect to server: 192.168.2.7 \ SRVDOC \ DOCSYSTEMSCAN in C: \ wamp \ www \ connection.php on line 2

Warning: mssql_select_db () expects parameter 2 to be resource, boolean given in C: \ wamp \ www \ connection.php on line 3

The current code is:

<?php
    $con = mssql_connect("192.168.2.7\SRVDOC\DOCSYSTEMSCAN", "sa", "minhasenha");
    mssql_select_db("fd_585b0f87", $con);
 ?>

I'm breaking my head but I do not know what could be ... Any suggestions? Thank you.

php sql-server

asked by anonymous 22.06.2014 / 01:46

3 answers

How to use a list in the ListView Footer? CodeIgniter opens many connections to the Database

score 1 · Answer 1

Friend, try following the template proposed in the official PHP manual page:

$serverName = "SRVDOC\DOCSYSTEMSCAN"; //serverName\instanceName
$connectionInfo = array( "Database"=>"fd_585b0f87", "UID"=>"sa", "PWD"=>"minhasenha");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

Reference: link

Or try this way with the "mssql_connect" function

$server = 'SRVDOC\DOCSYSTEMSCAN';
$link = mssql_connect($server, 'sa', 'minhasenha');

Reference: link

Good luck!

score 0 · Answer 2

According to what is written in the mssql_select_db function documentation a likely cause of this error may be the underscore contained in the database name.

To escape the name of a database that contains spaces, hyphens ("-"), or any other exceptional characters, the name of the database must be enclosed in square brackets, as shown in the example below. This technique should also be applied when selecting a database name that contains a reserved word (such as primary ).

To escape the character put fd_585b0f87 in brackets, like this:

<?php
    $con = mssql_connect("192.168.2.7\SRVDOC\DOCSYSTEMSCAN", "sa", "minhasenha") 
    or die ("Erro ao conectar-se ao BD: ".mssql_get_last_message());
    mssql_select_db('[fd_585b0f87]', $con);
?>

score 0 · Answer 3

You could try using PDO to SQLServer

<?php
  try {
    $hostname = "myhost";
    $port = 10060;
    $dbname = "tempdb";
    $username = "dbuser";
    $pw = "password";
    $dbh = new PDO ("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
  } catch (PDOException $e) {
    echo "Failed to get DB handle: " . $e->getMessage() . "\n";
    exit;
}