Edit report at https://bugs.php.net/bug.php?id=44300&edit=1
ID: 44300 Updated by: paj...@php.net Reported by: alfa77 at gmail dot com Summary: mssql_connect fails sometimes -Status: Open +Status: Wont fix Type: Bug Package: MSSQL related Operating System: Windows 2000 PHP Version: 5.2.5 Block user comment: N Private report: N New Comment: You should really move to 5.3+ and use http://pecl.php.net/sqlsrv Previous Comments: ------------------------------------------------------------------------ [2012-11-20 12:20:49] alfa77 at gmail dot com 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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
