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