Bug #10214 Updated: after 45min. of no user interaction, i get a can't connect to database/server

ID: 10214 Comment by: wade@wadejohnson.de Old Reported By: naikj@engini.nl Reported By: wade@wadejohnson.de Status: Closed Bug Type: ODBC related Operating System: windows 2000 prof. PHP Version: 4.0.4pl1 New Comment: I was just browsing the error reports and came across this issue. I had all kinds of problems getting Sybase SQLAnywhere to work with PHP and IIS. I finally found a way to make it work. I created an ODBC datasource that will only be used by PHP. The datasource uses the DBCLIENT.exe instead of connect to the server of the local interface. It is important that the datasource NOT BE CHECKED to automatically shut down when the last connection is closed. I am running PHP as an ISAPI on IIS. When the first PHP program makes a connection, the dbclient.exe is launched. You can see it in the task list on the task manager. If this app gets closed, then IIS will need to be restarted before it will reconnect correctly to the database. Note: I could not get a normal "local" odbc connection to work. This must be an issue with the way IIS is managing its memory (probably to keep IIS apps securely away from other running apps). Anyway, I hope this helps. Wade Johnson Previous Comments: ------------------------------------------------------------------------ [2001-04-27 21:53:31] kalowsky@php.net no user feedback. if this still exists, please reopen the bug. ------------------------------------------------------------------------ [2001-04-06 13:55:26] derick@php.net Please provide as much information as possible, and read www.php.net/bugs-dos-and-donts.php before posting a bug. (Another possibility is to disable the screensaver, or use a real OS) ------------------------------------------------------------------------ [2001-04-06 13:43:52] naikj@engini.nl running a IIS, PHP, Sybase SQLanywhere 5.0 after 45min. of no user interaction, (getting back from the screen saver), i get a can't connect to server/database. NEED HELP and quick ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=10214&edit=1