ADO.Net Connection Question

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,

What is the best way to test to see if a MS SQL DB is running? Does it
throw a specific error when trying to connect to it that I can catch? I am
trying to design my application if the db server is offline to save the db
info locally. Any ideas?

Thanks
 
Hi Mike,

If connection failed during opening, then you should get SqlException
exception. What you need to do is to place only Open method of the
connection into separate Try Catch block and see if it is opened or not
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO.NET OleDb connector problem with jet 10
Some doubts about ado.net 2
Suddenly slow ado.net connections 5
Loading ado.net table from datatableReader - wont update table on 2
How does ADO.NET handle transactions when the connection is broken 1
sybase ado driver dll open connection locked. 1
Question ADO with ASP.net 5
Reconnect after Oracle maintenance 1

Back
Top