From: [EMAIL PROTECTED]
Operating system: Windows 2000 Server SP2
PHP version: 4.3.0-pre2
PHP Bug Type: ODBC related
Bug description: odbc.check_persistent not working
Make sure the odbc.check_persistent is on and that odbc.allow_persistent is
on. Set up a database connection called dsnname
Run the script below (substituting [tabname] for a valid table name in
your database).
Check that you have persistent connections, ie with the webserver idle
make sure your database shows connections from the webserver.
Restart the database or kill the session belonging to the web server.
Re-run the script below and the odbc_exec fails with an error:
"connection not open" or smililar depending on your odbc driver.
I have found this effect to be the same with the Postgres odbc driver and
the Informix 3.30 odbc driver.
I presume that odbc.check_persistent is supposed to check that the
connection is still attached to the database before pconnect gives it to
the script?
<?
$dbconn = odbc_pconnect("dsnname","","");
$rid = odbc_exec($dbconn,"select * from [tabname]");
?>
--
Edit bug report at http://bugs.php.net/?id=20298&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=20298&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=20298&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=20298&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=20298&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=20298&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=20298&r=support
Expected behavior: http://bugs.php.net/fix.php?id=20298&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=20298&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=20298&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=20298&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20298&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=20298&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=20298&r=isapi
