#27553 [Opn->Fbk]: odbc.ini file descriptors left open

ID: 27553 Updated by: sniper@php.net Reported By: bradleyb at trans-soft dot net -Status: Open +Status: Feedback -Bug Type: Apache related +Bug Type: ODBC related Operating System: redhat 9 PHP Version: 4.3.4 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Also give us your full configure line used to configure PHP. Previous Comments: ------------------------------------------------------------------------ [2004-03-10 18:00:49] bradleyb at trans-soft dot net Description: ------------ When i make a connection to my sybase db using odbc_connect, apache leaves the odbc.ini file open even thought i call odbc_close(). I am unable to figure out how to get these files closed. I have done quite a bit of research but am unable to locate any one who has experienced this issue. Apache is the User assigned to the file which is located -> etc/odbc.ini At the top of each page that i load is an include statement that creates a connection to the db. When i have finished running my query (odbc_do()), i call odbc_close(). For each page that is loaded, a new instance of odbc.ini is opened for each call to odbc_connect(). I verify this by using -> lsof odbc.ini in the etc/ directory. Reproduce code: --------------- $db = odbc_connect($DSN, $dbUserName, $dbPassWord); if(!$db) { die("Failure to connect to DB"); } if(@ $dbResource = odbc_do($db, $query)) { if(@ odbc_fetch_row($dbResource)) { $myData = odbc_result $dbResource, "ColumnName"); } odbc_close($db); } Expected result: ---------------- The odbc.ini file descriptor located in the etc/ directory to be closed. Actual result: -------------- file is left open? lsof odbc.ini COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME httpd 20268 apache 8r REG 3,6 1105 244685 odbc.ini ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27553&edit=1