Checking Whether SQL Server Is Available

Friday Feb 13th 2004 by DatabaseJournal.com Staff
Share:

In Building ASP.NET database applications, in addition verifying a connection to the Net, you also need to ensure that your database server is up and running.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved