#33624 [Opn->Fbk]: pdo_odbc does not close connections

ID: 33624 Updated by: wez@php.net Reported By: gpd at gpdnet dot co dot uk -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows XP/IIS PHP Version: 5CVS-2005-07-09 (dev) New Comment: Hmmm, I turned that off on my local environment because it would crash during shutdown, 100% of the time. I've enabled it again in the snaps; if it doesn't blow up for you in the next snapshot, then it seems the problem is specific to my machine. Previous Comments: ------------------------------------------------------------------------ [2005-07-09 20:19:37] gpd at gpdnet dot co dot uk 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 this bug report at http://bugs.php.net/?id=33624&edit=1