Hi,
I did have that very same issue. Currently I have two possible solutions :
1 Start a transaction every once in a while (though this does tend to
increase server load when you have multiple clients)
2 Check the "connectioncount" of the server using
FirebirdSql.Data.Services.FbServerProperties . If it completes successfuly
- you have conectivity
I recommend using the second one, but you should keep a few things in mind
:
If you have no database connectivity, the FbServerProperties would throw
an exception - encapsulate it in try {} catch {} finally {}
Once the connection is down, you should reinit the FbServerProperties
object (create a new instance) before you use it again, otherwise it does
not seem to recover properly and gives "fake" exceptions (meaning you have
connection to the database, but the FbServerProperties object does not
agree with you :))
Though the firebird .net provider is not thread safe, I believe
FbServerProperties creates its own socket, so It should be safe to put it
on a seperate thread.
Hope this helps :)
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
