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