Subject | Re: [IBO] How to reconnect to DB |
---|---|
Author | Helen Borrie |
Post date | 2003-12-16T14:35:29Z |
At 02:07 PM 16/12/2003 +0000, you wrote:
What you do is catch the exception and (I think) call
IB_Connection.ForceDisconnect.
OnError event when this exception is detected.
Helen
>Hello,That's right.
>
>I establish a TCP/IP connection to a remote Firebird1.5RC7 DB (using
>TIBODatabase), when the server goes down or the cable is
>disconnected and then the server started and/or cable plugged in
>again, the connection is lost. Accessing opened tables causes an
>exception.
>
>TIBODatabase.Connected and TIBOTable.Active remain True, so my
>attempts
>'if not Connected then Connect' for the database and
>'if not Active then Open' for the tables
>don't solve that.
What you do is catch the exception and (I think) call
IB_Connection.ForceDisconnect.
>Please, how to reconnect to the DB again, how to realize theListen for the exception. Write a handler that can be called from the
>connection has been lost meanwhile?
OnError event when this exception is detected.
Helen