Subject | How to reconnect to DB II |
---|---|
Author | Andreas Bednarek |
Post date | 2004-01-09T12:05:32Z |
Hello!
I was not lucky some days ago, I'll try to repost my question since I didn't
find a solution yet.
Please how can I reconnect do DB (FB1.5 RC7) when the connection has
been lost? Beacuse the TIBODatabase.Connected property remains True, the
only way is probably to listen to the exception.
I implemented an TIBODatabase.OnError event handler, where it looks roughly
like this:
if ERRCODE = 335544721 then begin
Disconnect;
Connect;
end;
This works pretty well except that calling Disconnect displays an
message box 'Dataset is currently fetching' and you have to
click 'OK' !!!
It is necessary to avoid that dialog. I'm also not sure about the value
335544721 which has been discovered empiricaly.
Do you know any other way or how to tune my approach to reconnect to a
(remote) FB database?
thank you very much
Andreas
I was not lucky some days ago, I'll try to repost my question since I didn't
find a solution yet.
Please how can I reconnect do DB (FB1.5 RC7) when the connection has
been lost? Beacuse the TIBODatabase.Connected property remains True, the
only way is probably to listen to the exception.
I implemented an TIBODatabase.OnError event handler, where it looks roughly
like this:
if ERRCODE = 335544721 then begin
Disconnect;
Connect;
end;
This works pretty well except that calling Disconnect displays an
message box 'Dataset is currently fetching' and you have to
click 'OK' !!!
It is necessary to avoid that dialog. I'm also not sure about the value
335544721 which has been discovered empiricaly.
Do you know any other way or how to tune my approach to reconnect to a
(remote) FB database?
thank you very much
Andreas