note 28482 deleted from ref.mssql by sniper

Note Submitter: rwcatalano - the answer shop ---- Web Server Type: Windows 2000 Server SQL Server Type: Version 7 ERROR: Unable to load dynamic library '.\php_mssql.dll' - The specified module could not be found. in Unknown on line 0 ERROR: Unable to load dynamic library '.\php_mssql.dll' - The specified procedure could not be found. in Unknown on line 0 How To Fix: First in most circumstances you are getting this error because you have a older version of PHP installed (Such as 4.2.3), but you are trying to use a newer php_mssql.dll file (Such as the one that comes with 4.3.0) Step 1: Create a file called info.php that contains the single line: <?php phpinfo(); ?> -executing this file in your web browser will tell you what version of PHP you are running and it will through a couple of visual alerts displaying the errors mentioned above. Step 2: If you installed PHP using the installer you will have to go back to the php site and download the binary .zip file for Windows, for the version of PHP you currently have installed. Step 3: Open the zip file (you don't have to unzip the whole file becuase you are just looking to copy one (1) dll file, "php_mssql.dll". Step 4: Pending on whether you are running a default install, copy the "php_mssql.php" file to the following directory "c:\winnt\" Step 5: Double check that the following file exists: c:\winnt\system32\ntwdblib.dll Step 6: Edit your php.ini, search for the string "php_mssql.dll", and remove the semi-colon (;) from the front of the value. Step 7: Start and stop IIS Services by clicking the windows "start" button in the bottom left corner, select run, and type the command: net stop iisadmin (Type y at the promt) When the command window dissapears, click the windows "start" button in the bottom left corner again, select run, and type the command: net start w3svc Step 8: Run your info.php file again. If you did not get any errors, you are good to go; if you get the error again or your error looks like this: 'c:\program files\php\extensions\php_mssql.dll', then you need to move your "c:\winnt\php_mssql.dll" to the directory mentioned in the error message, for this example: "c:\program files\php\extensions\". Good Luck!!