MS SQL Server Concepts and Programming Question:

Download Questions PDF

In order to install the proper version of ntwdblib.dll on your machine, you need to find out how many copies of ntwdblib.dll do you have on your machine and what are the version numbers on those copies.

1. Go to Start > Search > All files and folders. Enter ntwdblib.dll in the "All or part of the file name:" field and click Search. You should see only one copy:

ntwdblib.dll C:php

Check the properties of this copy, you will see its version is 2000.2.8.0.

2. Rename C:php twdblib.dll to C:php twdblib.dll-old. Run this script:

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

You see this error message dialog box and an error in the command window:
Missing ntwdblib

PHP Warning: PHP Startup: Unable to load dynamic library
'./extphp_mssql.dll' - The specified module could not be
found.
in Unknown on line 0

Fatal error: Call to undefined function mssql_connect()
in C: estglobalguideline.php on line 2

This proves that there is only one copy of ntwdblib.dll on your machine. Read the next tutorial to see how to download the correct version of ntwdblib.dll for SQL Server 2005.