From: [EMAIL PROTECTED]
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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
