Check Connection From C# Application To SQL Server.

Hey anyone,

I got a problem to check a connection whether it is established or not from my C# Application to SQL Server.

I am developing my application which can run in 2 modes:

1. Online: There must be a connection to SQL Server to get new data updates.

2. Offline: I dont need a connection to SQL Server. I set a timer to tick every 5 seconds and it will check the connection with SQL Server and my problem here: (this is my code)1 public static bool checkConnection()
2 {
3 SqlConnection conn = new SqlConnection("mydatasource");
4 try
5 {
6 conn.Open();
7 return true;
8 }
9 catch (Exception ex) { return false; }
10 }


 Yes, it works but my application seems to wait about >3 seconds to get the return "False"; I tried to add "Connect TimeOut=1" in my Connection String, but the problem is still there.

I dont know whether there is a faster way to check the connection to SQL server which is established or not.

Thank you very much,

Joesy