Subject | RE: [IBO] connection problems with WLAN clients (timeout?) |
---|---|
Author | Alan McDonald |
Post date | 2007-02-20T00:11:48Z |
> Hi,ah - no. e.g. I leave IBExpert on all the time with my local dev dbs.
> on some client computers i have an application running (WinXP, D7, IBO
> 4.6). It connects to a FB 2.0 database on startup.
> The application then waits for quite a while (maybe 1, 2, 3 hours)
> until a user "logs in" (with a magnetic stripe card).
> At this moment the application becomes "active" and tries to identify
> the user in the DB, does a few actions... continues waiting.
>
> If I understand other post correctly, the connection is terminated by
> the server after 2 hours of inactivity (?).
Sometimes I go away for a week - when I get back the connection is still
live. dunno what you are referring to here. Maybe you are thinking of
connection thru firewalls where the firewall disconnects you and the server
then recovers resources from the loss of client connection.
> When the app tries to execute a query after that, I get the errorI suspect your firewall. Check the timeout settings there first.
> message "an established connection has been closed by the remote host"
> ("Eine vorhandene Verbindung wurde vom Remotehost geschlossen").
>
> The problem I'm trying to solve: How can I get this status BEFORE the
> query tries to execute. Looking at the IB_Connection's connected
> status returns TRUE, but executing the query raises this exception.
> Does the IB_Connection have some method like "check for valid
> connection"?
Alan
>
> TIA
>
> Lutz