MS SQL Server Concepts and Programming Question: Download MS SQL Server PDF
Where to Find ntwdblib.dll Version 2000.80.194.0?
Answers:
Answer #1You 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');
?>
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 #2Make 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!
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!
Previous Question | Next Question |
What Happens If ntwdblib.dll Is Missing on Your Machine? | How To Connect PHP with Different Port Numbers? |