C# & .NET Checking Database Connection

Question

I want to check availability of database connection so that I could put my application in specific modes; online mode and offline mode.

In order to do so, I try to open an OleDB connection (the database is Oracle) and if it is successful, the application shall run in online mode. However, if the database is down, opening the connection shall only be closed after specific period of time due to timeout.

Is there specific way of doing this without having to wait for the timeout? Or maybe, specify the timeout interval?

http://stackoverflow.com/questions/626984/best-way-to-check-oledbconnection-state — Habib, Sep 06 '12 at 09:01
So there is no way? If and only if there is a way of opening connection within specific window of time.. — Haikal Nashuha, Sep 06 '12 at 09:04

score 1 · Accepted Answer · answered Sep 06 '12 at 10:15

There is no other way then connecting to the database service.

However you could Mmdify the ConnectionTimeout property of your Connection instance before opening it to tweak the amount of time you want to wait.

On the other hand you could always start with the offline mode, do the connection check async and change the application behavior when the check was succeeded.

C# & .NET Checking Database Connection

1 Answers1