> Whatever the client was in the middle of is lost. Disconnect it and start
> the transaction over again.
>
> That's the only option you have.

> > Can someone tell me the way to restore connection that has been lost
> > because the restart on the server like that ?

We have this litle problem all the time, because the network
can not be relied on. IB5.6 used to leave the old connection
when we started a new one, so we had to switch to IB6.

Our mechanism uses a IB_DSQL to post the new data, and traps
the errors. If it does not work, it waits for a minute, then
tries again, until it succeeds. This means there can be
holes in the data, but you could always cache that
information locally until the connection is restored, and
then send all of the updates if needs be.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services