Subject Re: [IBO] TIB_Connection Losing Connection. PLEASE HELP
Author Helen Borrie
At 01:51 PM 30-10-02 +0200, you wrote:
>Ok i have tried calling CloseTransactions
>and also i loop through Transactions[i].CancelAll;

I suggested looping through Transactions[] and calling Close on each
one. However, this probably isn't going to work because, in order to
perform the enclosed rollbacks on the transactions, the GDS client has to
have a connection to the database.


>but then when i call IB_Connection.Connected := False;
>it still raises the exception "error writing data to the connection"
>
>what is it trying to write?

See above.


>did you not say that it is up to the application to set the state of
>connected, why does it not allow me?

Sorry, I've run out of client-side ideas and I don't have an ASTA setup to
test on. If ASTA is somehow controlling the states of the connection
handles it's presumably beyond the reach of the client.

HB