Check for SQL connectivity, if no redirec

My SQL Server went down and I had the dreaded:

Internet Explorer wrote: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Is there away to do something like this:

Check if SQL database is up.

If up, then connect to database with connection string

else, redirect to a static page that doesn't use SQL

or

show the page but use a different include that doesn't use SQL if only the include uses SQL.

Thanks.

That's cool.

Some of my static pages pull some information from the database (i.e. check to see if they are logged in to the forum or show a poll from the forum*), but that information is not required for the static part of the site. Its just a nice enhancement.

(*I'm creating a universal login to the website using WWF to store the users.)

With the code you gave above, I should also be able to tell it to not use certain includes or code that requires access to the database.

I think I am going to use that in all the code I write from now on.  I'd rather have them see my static pages and not get a 500 error.

Error checking is a good thing!