Testing for SQL Availability in ASP

[ccg]

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
access denied.

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 the error. I
have on error resume next but it still displays this error.

Thanks!

[Bob Barrows [MVP]]

ccg wrote:

> 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
> access denied.
>
> 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 the error. I
> have on error resume next but it still displays this error.
>
> Thanks!

On Error Resume Next is the only way. It should be catching this error. we
need to see your code.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bullschmidt]

Variable Types
[url]http://www.asp101.com/samples/var_types.asp[/url]
This has an example of some simple error handling.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!