ID: 38849 Updated by: [EMAIL PROTECTED] Reported By: dan dot mashal at gmail dot com -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Windows PHP Version: 5.1.6 New Comment:
Installing Client Tools will solve the problem, not a bug in PHP itself. Previous Comments: ------------------------------------------------------------------------ [2006-09-18 22:24:41] dan dot mashal at gmail dot com http://64.78.33.121/weberror.jpg ------------------------------------------------------------------------ [2006-09-18 18:52:47] [EMAIL PROTECTED] I do not have access to the web edition, so I asked what kind of errors you are getting when you try to install the client tools? One of the features of the client tools is the ability to set the default protocol used to communicate with SQL server. If the dll is copied you rely on the default setting in the dll you are using and that changes from version to version. The default used to be netbios but was changed to tcp/ip at some point. ------------------------------------------------------------------------ [2006-09-18 18:46:58] dan dot mashal at gmail dot com You are using standard edition. Try web edition. :) ------------------------------------------------------------------------ [2006-09-18 18:30:16] [EMAIL PROTECTED] This sounds odd to me. the SQL Server Client tools is only a conectivity pack and it installs fine on the full version of Windows Server 2003 (I'm using that combination). What kind of errors do you get when you try to install? ------------------------------------------------------------------------ [2006-09-18 18:29:25] dan dot mashal at gmail dot com 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. ------------------------------------------------------------------------ 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