I’ve been struggling for several hours to find out why PHP 5.2.5 didn’t want to connect to MS SQL Server 2005 Express Edition although extension=php_mssql.dll already enabled and phpinfo() is showing MS SQL already active.
I always got this error messages when trying to connect to MS SQL:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: (local)\SQLEXPRESS in path\mssql.php on line 5
After doing some searching, I got an answer that PHP 5 is using old ntwdblib.dll version. The one that comes with PHP 5.2.5 distribution is version 2000.2.8.0 which seems doesn’t compatible with the new MS SQL Server 2005 Express Edition. I downloaded new dll from http://webzila.com (use the search tool) which is version 2000.80.194.0 and replaced the one on PHP folder with this version.
I use this code to test the connection and its working:
echo("Testing MS SQL connection... ");
if ($conn = mssql_connect('(local)\SQLEXPRESS', 'user', 'pass'))
{
echo("Connection succeed");
mssql_select_db('dbname', $conn);
mssql_close($conn);
}
else
{
echo("Connection failed");
}
Tags:
php,
sql server