Reconnect does not work TADOconnection



Trying to handle network errors or communication errors returned to our
TADOconnection. Using an exception handler something like this:

if (E.message = 'communication link failure') then
begin
Conn1.Close;
conn1.open;
end;

To get the error I just turn off SQL server service and try to do a write in
the applicaton. The interesting thing is when the error happens the
connection is still open, so I force a close, then re open it. However, at
that point (with SQL server turned back on), the application does not
recover. It keeps getting the exception and DB operations do not work.

Any ideas?


.