Edit report at https://bugs.php.net/bug.php?id=44300&edit=1
ID: 44300 Comment by: kishorekumar dot doreshetty 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: 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. Previous Comments: ------------------------------------------------------------------------ [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! ------------------------------------------------------------------------ [2009-02-13 19:26:45] b116d at mail dot ru Same problem here. Apache 2.2.10 Php 5.2.5 as module. OS win2003 sp1+all critical updates I even try upgrade to php 5.2.8, but it still appears. ------------------------------------------------------------------------ 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