Not exactly a IBO question, but maybe IBO has some options or this mailing
list has some ideas or experiences:
My application is giving "-902 SQL:connection was lost" error after a longer
WinXP standby time.
---------
Fehler bei der Verbindung zur Hauptdatenbank fbsql:/firebird/wvo.fdb
Fehlercode:335544721
Errormessage:ISC Fehlernummer:335544721
ISC Fehlermeldung:
Unable to complete network request to host "fbsql".
Error reading data from the connection.
Eine vorhandene Verbindung wurde vom Remotehost geschlossen.
Errorcodes:335544721
2
25993068
1
SQLcode:-902
SQL:CONNECTION WAS LOST
-----

Trying to reproduce that this morning with a short 5min. standby time does
NOT show this error.
I assume it correlates to the firebird.conf parameter "connectiontimeout"
defaulted to 180minutes.
So I think it will show up after >180min. standby phase.

Well, for my customers that's kind of annoying on their daily work.
Any idea to avoid this problem?
Is there a way to auto-reconnect safely?

Regards
Gunther





___________________________________________________________
Der fr�he Vogel f�ngt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de