In ASP (vbscript) is there a way to check to see if a SQL server is
online before trying to open a connection?
I have a situation where we have a SQL server that may be offline for
a couple minutes and right the ASP page returns:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
I'd like to be able to first check to make sure the server is
available and if NOT, then skip the database connection on that page
altogether. Or, at least load the page without showing ...