php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: naikj at engini dot nl
New email:
PHP Version: OS:

 

 [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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Oct 24 07:00:01 2025 UTC