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

Reply via email to