PHP SQL Server driver not connecting

Question

I'm using the Zend CE server with PHP 5.3.5 and Eclipse Helios with PDT to develop a database-driven PHP web application. I have my dev environment setup and enabled the SQL_Srv driver through the Zend control panel.

My problem is in my script when I call the sqlsrv_connect() function, it fails to connect to my SQL Server db and always returns false. I've verified I can connect to the server through a System DSN as well as Microsoft SQL Server Management Studio, so I know it's there and I can talk to it. These same settings also work on my coworker's dev environment (the same as mine), so I'm not sure what's missing. Has anyone else had similar issues with the PHP SQL Server driver? The relevant snippet of code:

$serverName = 'dbServer';
$connectionInfo = array ( "Encrypt" => 0, "LoginTimeout" => 10,  "Database" => "Test_DB", "UID" => "ABC", "PWD" => "123" );

//This is always false.  Does not connect
$test_Connect = sqlsrv_connect ( $serverName, $connectionInfo );

$GLOBALS['_connection'] = sqlsrv_connect ( $serverName, $connectionInfo );

if ( $GLOBALS['_connection'] == false ) {
    print_r ( sqlsrv_errors(), true );
    die ( "Failed to connect to SQL Server '$serverName'." );
}

Do a phpinfo() to make sure that PHP has the necessary SQL Server extensions compiled in. — Jarrod Nettles
– Jarrod Nettles, Commented Jun 27, 2011 at 21:20
Hi Jarrod, yes I checked phpInfo(), I can see "sqlsrv" in the list of registered PHP streams. — kingrichard2005
– kingrichard2005, Commented Jun 27, 2011 at 21:36

kingrichard2005 · Accepted Answer · 2011-07-01 18:24:19Z

1

Turns out PHP SQLSrv driver requires the Microsoft SQL Server 2008 Native Client to function. Make sure it's the '08' client and not '05', I already had the native client for SQL Server 2005 installed while experiencing this issue. It was only after I installed the client for SQL Server 2008 that it worked properly. Hope this helps others.

answered Jul 1, 2011 at 18:24

kingrichard2005

7,31921 gold badges91 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP SQL Server driver not connecting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related