Where to Find ntwdblib.dll Version 2000.80.194.0?
Submitted by: AdministratorYou 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');
?>
Submitted by: Administrator
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');
?>
Submitted by: Administrator
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!
Submitted by: Administrator
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!
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | What Happens If NULL Values Are Involved in Arithmetic Operations? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | How To Use Subqueries in the FROM Clause in MS SQL Server? |
☺ | How To Use Subqueries with the EXISTS Operators in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |