Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Finding ntwdblib.dll Version 2000.80.194.0

By: FYIcenter.com

(Continued from previous topic...)

Where to Find ntwdblib.dll Version 2000.80.194.0?

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:\ntwdblib.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','FYIcenter');
?>

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

C:\test\>copy c:\php\ntwdblib.dll-old c:\php\ntwdblib.dll

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

C:\test\>copy c:\php\ntwdblib.dll-new c:\php\ntwdblib.dll

C:\test>\php\php fyi-center.php
(No warning messages)

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

(Continued on next topic...)

  1. How To Download and Install PHP on Windows?
  2. How To Check Your PHP Installation?
  3. What Do You Need to Connect PHP to SQL Server?
  4. How to Turn on the MSSQL API Module?
  5. What Is Wrong with SQL Server Client Libarary DLL, ntwdblib.dll?
  6. What Happens If ntwdblib.dll Is Missing on Your Machine?
  7. Where to Find ntwdblib.dll Version 2000.80.194.0?
  8. How To Connect with Different Port Numbers?
  9. What Are Commonly Used MSSQL Functions in PHP?
  10. How To Disconnect from a SQL Server using mssql_close()?
  11. How To Select an Exiting Database using mssql_select_db()?
  12. How To Execute a SQL Statement using mssql_query()?
  13. How To Retrieve Error Messages using mssql_get_last_message()?
  14. How To Turn Off Warning Messages during PHP Execution?
  15. How To Receive Returning Result from a Query?
  16. How To Loop through Result Set Objects using mssql_fetch_array()?
  17. How To Retrieve Field Values using mssql_result()?
  18. How To List All Field Names in the Result Set using mssql_field_name()?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...