ID: 38849 User updated by: dan dot mashal at gmail dot com Reported By: dan dot mashal at gmail dot com Status: Open Bug Type: MSSQL related Operating System: Windows PHP Version: 5.1.6 New Comment:
To Tony: You just get a generic mssql_connect failed error. This is a known bug. >From http://www.php.net/mssql_connect "damartman (tradestudios.com) 23-Aug-2006 12:29 I am running MS SQL Server 2005 Workgroup Edition on Windows 2003 with PHP 5. I could not connect to a MS SQL database using mssql_pconnect(); until I read a post from ashraf (aat) ametry.com on 01-May-2006 01:25. However, my fix was simply to: 1. Replace the ntwdblib.dll with the one from http://webzila.com/dll/1/ntwdblib.zip in my c:\php5 folder. 2. Restart IIS REASON: The ntwdblib.dll should be version 2000.80.194.0, and not version 2000.2.8.0 that PHP 5 ships with. Thank you ashraf for posting your note, however, changing the php.ini file value mssql.secure_connection = On did not work. I left it mssql.secure_connection = Off and that worked (the default to connect through NT/Windows Authentication) " This zip is basically the same ntwdblib.dll that ships with the MSSQL2000 CD. Previous Comments: ------------------------------------------------------------------------ [2006-09-18 18:25:48] dan dot mashal at gmail dot com This does not solve the problem. You cannot install MSSQL 2000 Client tools on Windows 2003 web edition. ------------------------------------------------------------------------ [2006-09-18 17:57:28] [EMAIL PROTECTED] Copying the ntwdblib.dll is never a good option. Use the install process on the MSSQL Server to install the Client Tools. That will install the correct version of ntwdblib.dll and other tools that makes it possible to use all features and gives acces to the configuration tools. Installing Client Tools will not install the server. ------------------------------------------------------------------------ [2006-09-18 17:56:10] [EMAIL PROTECTED] Do you get any error messages? ------------------------------------------------------------------------ [2006-09-18 17:30:06] dan dot mashal at gmail dot com And by "does not work" I mean PHP is unable to connect to MSSQL databases. ------------------------------------------------------------------------ [2006-09-18 17:29:21] dan dot mashal at gmail dot com I mean that you have to copy the ntwdblib.dll that is on the MSSQL2000 CD. Otherwise it doesnt work. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/38849 -- Edit this bug report at http://bugs.php.net/?id=38849&edit=1
