I had the same problem in my software using threads. IBX is not thread safe and if you use different queries (TIBQuery / TIBSQL, etc) in threads, you could have a working system for some time but receive errors (like the one you mentioned) once in a while, errors that you cannot reproduce.



Tiberiu


From: wijanarko_bambangw
Sent: Thursday, July 02, 2009 11:36 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Client lost connection to FB server (Intermmitent)





I have a delphi 5 application connect to FB 1.5.4 Super Server by IBX Component. FB Server run on Windows Server 2003.
everything work fine until we upgraded to Firebird to 2.0.5.
this is intermmitent case where client has successfully connect to FB and run application function. but after a while, suddenly the connection is lost and raise :

"unable to complete network request to host XXX
error writing data to the connection
an existing connection was forcibly closed by remote host"

even the application run idle. while the exception raise, other client connection are running well, and it could be raise in other client too.
I have switched FB to Classic Server and switched the server to XP operating system, but error still happened.
Does anyone have an idea to solve this problem ?

Thanks
Bambang





[Non-text portions of this message have been removed]