Bug #14948: mssql_pconnect opens connection everytime is called

From: spilka@adash.cz Operating system: NT 4.0 SP5 PHP version: 4.1.1 PHP Bug Type: MSSQL related Bug description: mssql_pconnect opens connection everytime is called Apache 1.3.22 Win NT SP5 PHP 4.1.1, run as DLL Apache module MSDE SQL server mod_mssql module loaded Problem: When opening connection to MSSQL database with mssql_pconnect, the connections are not persistently used. Instead, new connection is opened everytime. See MSSQL sp_who2 results: SPID Status DBName Command CPUTime DiskIO LastBatch ProgramName SPID ----- ---------- ------ ---------------- ------- ------ -------------- -------------- ----- 1 sleeping master SIGNAL HANDLER 0 0 01/09 15:07:02 1 2 BACKGROUND UKOLY LOCK MONITOR 0 0 01/09 15:07:02 2 3 BACKGROUND UKOLY LAZY WRITER 0 0 01/09 15:07:02 3 4 sleeping UKOLY LOG WRITER 0 0 01/09 15:07:02 4 5 sleeping UKOLY CHECKPOINT SLEEP 0 0 01/09 15:07:02 5 6 BACKGROUND UKOLY AWAITING COMMAND 0 5 01/09 15:07:02 6 7 RUNNABLE UKOLY SELECT INTO 0 169 01/09 15:41:39 MS SQL Query 7 8 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:34 PHP 4.0 8 9 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:31 PHP 4.0 9 10 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:37 PHP 4.0 10 11 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:39 PHP 4.0 11 12 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:40 PHP 4.0 12 13 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:41 PHP 4.0 13 -- Edit bug report at: http://bugs.php.net/?id=14948&edit=1