Subject | Re: [firebird-support] Re: Checking connection in advance to connecting |
---|---|
Author | Bogusław Brandys |
Post date | 2005-07-04T11:24:37Z |
georgethenorge wrote:
non-frequent connection to central database server ? Replication ?
How an Firebird client would crash an hour after losing connection to
server ? Seems that you need a simple select * from testtable , where
testtable is sigle record sized - to test if connection is still alive
before proceed with some complicated work.
Do you use Firebird events?
Regards
Boguslaw Brandys
>>Well...yes...the API will return an exception if the serverDo you mean you use "briefcase" ? Offline embedded database with
>
> resource
> is not
>
>>available. Is there any reason why you can't put the call to IBO's
>
> Connect
>
>>method inside a try...except block and use this built-in facility?
>
> :-)
>
>
> That is what I have been doing for about a year now, and it has
> worked
> well. But now I have a customer with four sites and a strange
> network. When the client lost the network, it would crash an hour
> later. And they don't need the network - they are made to survive
> and
> do their jobs without contact for up to a couple of weeks. To
> accomplish this, I made an auto-connect setup, where I use a TTimer
> to
> disconnect and reconnect, if the PING shows up OK. What happened is
> that if I did it enough, app memory use would grow and grow. I can
> reproduce the problem with a VPN client here at home.
>
> I'll do whatever work I need to - where can I dig deeper?
>
> -George
non-frequent connection to central database server ? Replication ?
How an Firebird client would crash an hour after losing connection to
server ? Seems that you need a simple select * from testtable , where
testtable is sigle record sized - to test if connection is still alive
before proceed with some complicated work.
Do you use Firebird events?
Regards
Boguslaw Brandys