Subject Re: [firebird-support] Detecting unavailable server
Author W O
Hello:

I simply before any command try to get the time of the Server. If it is
successful then application can communicate.

Greetings.

Walter.




On Wed, May 30, 2012 at 3:43 AM, sasidhardoc <sasidhardoc@...> wrote:

> **
>
>
> I am developing an application using FB 2.5 and the .NET provider. In
> addition to usual Db operations, the application subscribes to database
> events which are used to trigger UI refreshes etc
> Since some of the users use wireless connections, I would like to be able
> to detect unavailable database connection & notify user. I can think of 3
> ways to do this - comment and suggestions are welcome.
> 1. Frequently poll the db and try to connect. Easiest way but in reality I
> will have a couple of hundred clients frequently trying to connect to the Db
> 2. Start a connection and transaction, keep alive for the duration of
> application, periodically try to run a query. Not sure if this is much
> better than 1 except that I am not opening and closing
> 3. Use a server side application to post a heartbeat event. Have all
> clients subscribe to this event
>
>
>


[Non-text portions of this message have been removed]