how to check firebird server service is running ?

[tpv]

hi,

we have a some issues with firebird when we have lan problems or firebird service is down
with message "access violation" ,this message still appears even if we resolve the lan problems

is there a way to check firebird server service is running ? or disconnect form the database when firebird service is down ?
( using zeos 7.0.3, lazarus 1.14 , firebird 2.5.1)

thanks ;

[EgonHugeist]

Hi,

this is true. Zeos actually does'nt handle connection lost issues. This is planned on 7.3 (my idea). You could Ping the server and use the code in a try .. except block (i'm not a fan of it since it slows down the compiled apps a bit).

TZConnection.DbcConnection.Ping

[Sergiomaster]

Hello ,

I ran also in that issue (wifi out of range) .
my workaround was first to use the TZConnection.DbcConnection.Ping (i saw also yesterday a TZConnection.DbcConnection.Pingserver difference ?)
but the time out seems to be too long . I use François Piette ICMP unit instead (only one unit of his ICS component suite found here http://www.overbyte.be/frame_index.html)

This is planned on 7.3 (my idea).

yearn to see it

Serge