Subject | Re: DB disconnection issue |
---|---|
Author | DanyM |
Post date | 2012-09-02T15:58:51Z |
--- In IBObjects@yahoogroups.com, "Dayna" <quathiaski@...> wrote:
IBO is cool about lost connections, but it will require you to code good. You can check the error code in the session error handler with the ConnectionLostErrcode boolean function. Do a forced disconnect and then connect again. You'll need to post or broadcast to open datasets to re-open. Basically, it should be doable to code reconnect facilities with IBO. It is, alas, not a trivial task (IBO or not). There's also a KeepConnection property of the TIB_Connection component. The default is true though, so i suspect that won't be of any help to you.
HTH,
/Dany
>I suspect your post ended up under another thread. Yahoo will thread your posts when you "reply" and change the subject (bad, bad). Did you get any help with this?
> I'm not sure if this is on topic or not.
>
>
>
> I am running a 4.x version on Delphi 2006 Pro.
>
>
>
> We are connecting to a database and having no issues until one of our
> clients upgraded to a 'green feature' router that shuts inactive ports down
> to save power. This causes us to become disconnected from the database.
>
>
>
> Is there no way to detect such a connection loss in your component set? Is
> there a keep alive signal I can send every minute or so to keep this green
> feature from killing the connection?
>
>
>
> If I should be asking somewhere else please point me there and I will ask
> again there instead.
>
>
>
> Thanks,
>
> Dayna
>
>
>
> Quathiaski Software.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
IBO is cool about lost connections, but it will require you to code good. You can check the error code in the session error handler with the ConnectionLostErrcode boolean function. Do a forced disconnect and then connect again. You'll need to post or broadcast to open datasets to re-open. Basically, it should be doable to code reconnect facilities with IBO. It is, alas, not a trivial task (IBO or not). There's also a KeepConnection property of the TIB_Connection component. The default is true though, so i suspect that won't be of any help to you.
HTH,
/Dany