From: [EMAIL PROTECTED] Operating system: Red Har 7.3 PHP version: 4.2.1 PHP Bug Type: ODBC related Bug description: ODBC fails to close connections
I'm using PHP 4.2.1 with unixODBC and FreeTDS to connect to MSSQL 7.0 and MSSQL 2000 servers. I have a problem with the database connection not being closed by PHP. I've tried combinations of odbc_connect, odbc_pconnect, odbc_close, odbc_close_all, and not calling any close function. ( the documentation claims the connection will close automaticaly when the script terminates ) All combinations I've tried leave an open connection on the server. If I use the 'isql' program, again with unixODBC and FreeTDS, I do not have this problem. I've had the same problem on RH7.0 and RH7.3 and with PHP 4.0 to 4.1.2. What's Up? Further investgation with Ethereal and netstat show after PHP excutes an odbc_exec() PHP receives the data then never sends anither packet to the sever leaving the socket in an ESTABLISHED state. Neither odbc_close() nor odbc_close_all() send any packets. -- Edit bug report at http://bugs.php.net/?id=19946&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19946&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19946&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19946&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19946&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19946&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19946&r=support Expected behavior: http://bugs.php.net/fix.php?id=19946&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19946&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19946&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19946&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=19946&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=19946&r=dst IIS Stability: http://bugs.php.net/fix.php?id=19946&r=isapi