#33624 [NEW]: pdo_odbc does not close connections

From: gpd at gpdnet dot co dot uk Operating system: Windows XP/IIS PHP version: 5CVS-2005-07-09 (dev) PHP Bug Type: PDO related Bug description: pdo_odbc does not close connections Description: ------------ In the latest 5.1 snapshots the pdo_odbc driver does not close connections to the database server. run the below code mulitple times by re-requesting the page. After several requests there are lots of idle connections at the database server Tried this with odbc connection pooling on and off. Tried this with SQLServer and Sybase SQLAnywhere. After a while running my code there are hundreds of connections on the server, even after leaving for an hour. Only killing the dllhost process will free the connections Even explicitly assigning null to the connection recource does not disconnect. Reproduce code: --------------- $cn = new PDO('odbc:DRIVER={SQL Server};Server=GARY;Database=cct8740','sa','ashwell'); -- Edit bug report at http://bugs.php.net/?id=33624&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33624&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33624&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33624&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33624&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33624&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33624&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33624&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33624&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33624&r=support Expected behavior: http://bugs.php.net/fix.php?id=33624&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33624&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33624&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33624&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33624&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33624&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33624&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33624&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33624&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33624&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33624&r=mysqlcfg