I've searched this subject in this group and others. It seems there is no single cause for this. Even so, I would welcome any input. This seems to be a common problem with other RDBMS as well, so I'm sure it isn't a Firebird problem, but perhaps there is some "setting" I've overlooked. I still consider myself a Firebird novice. Server: Windows XP with all updates current.Database: Firebird 2.1Client 1: Windows 7 - 64 bit Intel I7 - Wireless connectionClient 2: Windows XP 32 bit AMD Dual Core - Wired connection (this is not the server).Language: Delphi 2007 - Data access via IBDAC components (devart). Application: Customer lookup and support data.The program normally has only one table open using an IBDAC Query component. The data is displayed one record at a time (not a grid). There are a good number of other tables, but they are not open when this problem occurs. Condition/Symptom: Within 15 or 20 seconds of opening the database, the program freezes for a short period before returning the error: "... an existing connection was forcibly closed by the remote host." This happens while navigating from one record to the next. It also happens in the same amount of time when sitting idle. Examination of Firebird.log shows multiple coinsurances of : MYCOMPUTERNAME (Server) Thu Mar 29 18:11:06 2012 INET/inet_error: send errno = 10054 MYCOMPUTERNAME (Server) Thu Mar 29 18:19:03 2012 INET/inet_error: read errno = 10054 Assumptions:Since 10054 = "Connection reset by peer", I assume the origin of both messages is occurring on the server, and they are both reporting same condition. Question:If my assumption is correct, is there something I need to do with Firebird that will prevent/minimize this? I'm leaving town for the weekend, will not have time to look at the server until Monday. I plan to look at Firewall and FileZilla settings, Should I check anything else? More background:I have a server application (also written in Delphi using Indy) running on the same server in the same domain. It has been running flawlessly for many months. This same machine, router and switch has been my web server for over a year.
[Non-text portions of this message have been removed]
