note 57973 added to function.mssql-connect

I have spent the last 2 days trying to get PHP to connect to MSDE on Windows 2003 Web Edition. Although initally PHP would connect to the database without a problem, it would then refuse to connect, hitting F5 enough times would eventually connect to the database. As you can imagine this intermittent problem was hard to trace. I was using PHP 5.0.5 (although 5.0.4 has the same problem) on a Windows 2003 Web Edition SP1 server, and was trying to connect to MSDE Rel A. Solution: ~~~~~~~~~ Firstly MSDE needed to be installed with the following arguments: SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0. Secondly it was necessary to delete ntwdblib.dll from c:\php Thirdly I downloaded the SQL 2000 evaluation and installed only the client tools on a seperate PC (Ent. Manager will now connect to the database). Lastly I copied the version of ntwdblib.dll from the PC with Ent. Manager on it (ver 2000.80.2039.0) to c:\windows\system32\ After a re-boot no more connection problems. Pls note that this is only for 2003 Web Edition with MSDE, this problem does not seem to occour with Standard Edition ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+57973 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+57973&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+57973&report=yes Search -- http://master.php.net/manage/user-notes.php