Edit report at https://bugs.php.net/bug.php?id=44300&edit=1
ID: 44300
Comment by: alfa77 at gmail dot com
Reported by: alfa77 at gmail dot com
Summary: mssql_connect fails sometimes
Status: Open
Type: Bug
Package: MSSQL related
Operating System: Windows 2000
PHP Version: 5.2.5
Block user comment: N
Private report: N
New Comment:
I think that this bug is not related to connection limit.
I have closed each connection at the end of the script (although it is not necessary due to
documentation:
----------------------------
mssql_close <...>
Note that this isn't usually necessary, as non-persistent open links are automatically closed
at the end of the script's execution.
----------------------------
Also, exec sp_who2 did not show a lot of connections (no more than 200).
I have solved this problem by using another extension (odbtp as a gateway on Windows server, PHP is
hosted now on UNIX) - everything is all right now.
Previous Comments:
------------------------------------------------------------------------
[2012-11-20 11:50:15] kishorekumar dot doreshetty at gmail dot com
Problem is due to connection limit. it would be good if you close connection once your done with sql
part. use mssql_free_statement(resouceid) and connection close to db every page of you site.
------------------------------------------------------------------------
[2010-07-17 18:59:07] opc dot three at gmail dot com
Related to Bug #35217.
------------------------------------------------------------------------
[2010-02-25 10:18:16] healerx78 at yahoo dot com
trials
------------------------------------------------------------------------
[2010-01-19 08:41:40] t dot zander at tuneup dot de
We're experiencing the same problem with Microsofts SQLSRV driver.
So it might be it's not just a driver problem.
------------------------------------------------------------------------
[2009-12-03 17:37:29] dbuerer at leviton dot com
I too have suffered this same problem for the last couple of years on all of the 5.x release of PHP.
It works great for days then has problem for a few days then works great. 1-3 page reloads often
solves the problem but not always. Unfortunatley support for this extension has been discontinued--I
wonder if this is one of the reasons why? I would like to try using Microsofts SQLSRV driver but
converting an entire website from mssql to sqlsrv is going to be a lot of work!
------------------------------------------------------------------------
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
https://bugs.php.net/bug.php?id=44300--
Edit this bug report at https://bugs.php.net/bug.php?id=44300&edit=1