note 57973 deleted from function.mssql-connect by cmb

Note Submitter: dave at phantomfish dot co dot uk ---- 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