Need to check whether DB is up or not.RSS

• • Reply
  pure_m23

  None

  0 Points

  5 Posts

  Need to check whether DB is up or not.

  Jan 24, 2012 02:38 AM|pure_m23|LINK

  Hi,

  I am using enterpriseLib 3.1. 
  Below is a code snippet, which I am using to check whether conneciton is up or not. 

  But the code at times does not throw error even when I have disconnected the cable. 

  My app is database agnostic, so the code should work with any DB type.

  Database _db = DatabaseFactory.CreateDatabase("Connection Config Key");
  System.Data.Common.DbConnection _conn;
  
  do
  {
      try
      {
             _conn = _db.CreateConnection();
             _conn.Open();
             _conn.Close();
             _conn.Dispose();
  
             break;//Connection is established
      }
      catch(Exception)
      {
         //No Connection... retry
      }
  }while(true);

  Regards,

  M

• • Reply
  Rab Nawaz Kh...

  Member

  633 Points

  224 Posts

  Re: Need to check whether DB is up or not.

  Jan 24, 2012 02:55 AM|Rab Nawaz Khan|LINK

  please visit the below URL, it may solve your problem

  http://stackoverflow.com/questions/927567/in-c-sharp-what-is-the-best-way-to-determine-if-a-database-is-up-and-running

  Please mark as answer if this post answered or solved your problem.
• • Reply
  ignatandrei

  All-Star

  120084 Points

  27963 Posts

  Moderator

  MVP

  Re: Need to check whether DB is up or not.

  Jan 24, 2012 02:55 AM|ignatandrei|LINK

  read at least a table.

  .NET Teacher | .NET Videos 5 minutes
• • Reply
  pure_m23

  None

  0 Points

  5 Posts

  Re: Need to check whether DB is up or not.

  Jan 25, 2012 02:31 AM|pure_m23|LINK

  I am doing that now. I think the code snippet, which I have mentioned was failing to detect strictly whether the DB is up or not because the connection object is pooled. I want to know if there is any better way of achieving the same ?

  Regards,

  M

• • Reply
  pure_m23

  None

  0 Points

  5 Posts

  Re: Need to check whether DB is up or not.

  Jan 25, 2012 02:46 AM|pure_m23|LINK

  HI Khan,

      If you look at my code, I am doing the same, but what's happening is even if I disconnect the cable, the _con.Open executes without any error and the connection State also shows OPEN. I added one additional step where I am querying something from table, this steps ensures if the DB is up or not. Don't think this soln is elegant but till I get a better soln, I will go with that approach.

  Regards,

  M