php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #10214 after 45min. of no user interaction, i get a can't connect to database/server
Submitted: 2001-04-06 13:43 UTC Modified: 2001-04-27 21:53 UTC
From: naikj at engini dot nl Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.4pl1 OS: windows 2000 prof.
Private report: No CVE-ID: None
 [2001-04-06 13:43 UTC] naikj at engini dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-06 13:55 UTC] 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-27 21:53 UTC] kalowsky@php.net
no user feedback.  if this still exists, please reopen the 
bug.
 [2002-01-16 10:38 UTC] wade at wadejohnson dot de
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
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 28 07:01:29 2024 UTC