Subject How to handle breaks in Connections
Author Michael L. Horne
Hello

I have a program that connects to a DB across the internet.
Sometimes the internet connection drops during data transfer.

Doing some test where I made a connection then broke it by
unplugging the cable. There was no error until the next command
tried to access the server. I attempted to do:

TIB_Connection.Connected := False;

And got the following error:

ISC ERROR CODE:335544721

ISC ERROR MESSAGE:
Unable to complete network request to host "207.65.98.240".
Error reading data from the connection.
An existing connection was forcibly closed by the remote host.

The "TIB_Connection.Connected" still reported TRUE. Even after
the error message.

So, what is the best procedure to terminate the current
connection/rollback, reestablish a new connection, and continue?

Also, I get similar messages when transmitting data and the
connection drops.

Thanks
Michael L. Horne