Checking Whether SQL Server Is Available

February 13, 2004

[From developer.com]

When you're designing applications that work with databases over the Internet, perhaps the largest problem you face is ensuring that everything can actually connect to everything else. You need to ensure that your users have a valid connection to the Net, and you need to ensure that your database server is up and running.

It's not a typically easy process--and it's a topic that attracts an unusually large amount of error handling code.

However, why not take the simple route and avoid potential big errors later on by checking whether your SQL Server is available to the user before starting your database code?

The article continues at http://www.developer.com/net/asp/article.php/3312601