ID: 40034 Comment by: hamzeh dot shaar at ifpexpo dot com Reported By: chris dot clos at lmcu dot org Status: Assigned Bug Type: MSSQL related Operating System: Windows Server 2003 PHP Version: 5.2.0 Assigned To: fmk New Comment:
Guys, I have the same problem. I have php 5.2.6 on IIS 6. I cannot connect from it my SQL server 2000 (MSDE) running on the same machine knowing that i have another PHP installation 5.2.5 on the same LAN and it connects to the same MSDE 2000 Normally. I tried copying php5isapi.dll and ntwdblib from the working machine to the other and still it dd not work. any suggesstions? Previous Comments: ------------------------------------------------------------------------ [2008-10-10 08:35:20] dirk dot melcher at mdk-nord dot de thanks everybody for the hints that helped me a lot! I'm using php Version 4.2.1 and the same problem applied to me. I downloaded an appropriate version of ntwdblib.dll at: http://www.dlldll.com/ntwdblib.dll_download.html Bye, Dirk ------------------------------------------------------------------------ [2008-09-18 13:14:23] spanidis at certh dot gr Hello to everyone. Could you please tell us where can we download ntwdblib.dll (ver. 2000.80.2039.0) from? Thanks for your help Pavlos ------------------------------------------------------------------------ [2008-08-15 11:51:08] php at blazemonger dot com I am experiencing this on Linux (CentOS 5) with the stock PHP 5.1.6 and PHP 5.2.6. It is intermittent -- the same SQL query to the same DB server will work sometimes, fail other times. ------------------------------------------------------------------------ [2008-07-29 12:37:13] c dot pasticcio at gawab dot com We have the same problems with sevral configurations on windows 2003. - webserver: win2k3 + Apache 2.2.9 + Php 5.2.6 - webserver: win2k3 + Apache 2.0.59 + Php 5.1.6 - db server: win2k3 + sql server 2000 We have other 2 webservers with latest Apache and Php releases running on windows 2000 that don't suffer this problem. On all webservers we have ntwdblib.dll version 2000.80.194.0. On db server with win2k3 we have a ntwdblib.dll version 2000.80.2039.0. We didn't try to change the libs yet. ------------------------------------------------------------------------ [2008-07-23 00:01:23] efesar at gmail dot com Recently I upgraded to PHP 5.2.6 (Apache 2.2.9, Win2003 SP2, MSSQL 2000 SP4 on a separate box) from 5.1.2 (Apache 2.0.58) and this problem suddenly reared its ugly head. Apache wouldn't connect to the database for more than a few hours. PHP was running the "2000.2.8.0" DLL ... I copied the "2000.80.2273.0" DLL over from the MSSQL 2000 box and restarted the web box. I'm hoping this fixes the issue. We tried to use Microsoft's 2005 PHP driver, but it was hopelessly bad at managing resources (If we ran more than 15 calls to sqlsrv_query() in a single PHP session, it crashed PHP and Apache consistently). So far, so good. If this solution doesn't work within 72 hours to fix the problem, I'll come back to add another comment so that people reading this bug report will know it's still a problem. Otherwise, if I'm not back in a week or so, assume the DLL swap is the fix. Incidentally, we also run a PostgreSQL box. We connect to both MSSQL and PGSQL from the same web server, and the PGSQL connection has never failed. ------------------------------------------------------------------------ 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/40034 -- Edit this bug report at http://bugs.php.net/?id=40034&edit=1
