I have client/server applications written in VB6 that use ODBC to access Firebird databases. The Firebird database server runs on server.
The applications on clients run fine while in use. But When we leave the application after 30 minutes or more the following message is displayed:
"[ODBC Firebird Driver] [Firebird] Unable to complete network request to host "myHostName". Error reading data from the connection. An existing connection was forcibly closed by the remote host."
The user must close the program and reopen it to continue, it does not crash their system. After reopen, the program is back to normal.
Any suggestions on how to fix this?