MS SQL Server Concepts and Programming Question:

Download Questions PDF

Answer #1
You know that the copy of ntwdblib.dll version 2000.2.8.0 included in Windows binary version of PHP 5.2.3 does not work with MS SQL Server 2005. You need to get a new version of ntwdblib.dll.

One way to get a free copy of ntwdblib.dll is to download MS SQL Server 2000 SP4 from Microsoft Website. It contains a copy of ntwdblib.dll version 2000.80.194.0 in the system directory.

Copy ntwdblib.dll from SQL Server 2000 SP4 package to C: twdblib.dll-new. Check the properties of this file, you will see the version is 2000.80.194.0. Enter this single-statement script, fyi-center.php, for testing:

<?php
mssql_connect('LOCALHOST','sa','GlobalGuideLine');
?>

Answer #2
Make sure your SQL Server 2005 is running on your machine. Run the following tests in a command line:

C: est>copy c:php twdblib.dll-old c:php twdblib.dll

C: est>phpphp fyi-center.php
Warning: mssql_connect(): Unable to connect to server:
LOCALHOST in C: estglobalguideline.php on line 2

C: est>copy c:php twdblib.dll-new c:php twdblib.dll

C: est>phpphp globalguideline.php
(No warning messages)

These tests show that ntwdblib.dll version 2000.80.194.0 is working with MS SQL Server 2005 Express Edition!