ID: 20298
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Analyzed
Bug Type: ODBC related
Operating System: Windows 2000 Server SP2
PHP Version: 4.3.0-pre2
New Comment:
I'm unable to reproduce this on the UNIX end of things. Anyone with a
Windows boxen working that can test this?
Previous Comments:
------------------------------------------------------------------------
[2002-11-07 07:41:49] [EMAIL PROTECTED]
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 this bug report at http://bugs.php.net/?id=20298&edit=1
