Edit report at https://bugs.php.net/bug.php?id=44300&edit=1
ID: 44300
Updated by: pajoye@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