Testing for SQL Availability in ASP

Discussion in 'ASP General' started by ccg, Aug 5, 2004.

  1. ccg

    ccg Guest

    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.

    ccg, Aug 5, 2004
    1. Advertisements

  2. Already answered over in .db

    Please do not multipost ccg. This is definitely a database-related
    question so .asp.db was the perfect group in which to post it. Posting it
    here as well did not increase your chances of getting an answer (most of us
    subscribe to both groups). On the contrary, if somebody had taken his time
    to answer it here, only to find that it was already resolved in the other
    group, that person may have been annoyed enough to ignore any future posts
    from you, thereby decreasing your chances of getting help in the future.

    There are times when you will not be sure which group is most appropriate
    (again, this was not one of them), and you will want to post a question to
    both groups. In that situation, you should use the cross-posting technique,
    rather than posting the same message multiple times. To crosspost, put
    a semicolon-delimited* list of the newsgroups to which you wish to post in
    the To: header of your post and post it once. It, and any replies to it,
    will appear in all the newsgroups in your list. So, if I reply in .asp.db,
    my reply will also appear here in .asp.general.

    * ... or whatever delimiter is recognized by your news client

    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"
    Bob Barrows [MVP], Aug 5, 2004
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bob
    Aug 16, 2007
  2. VB Programmer

    Travel site - travel data availability?

    VB Programmer, Nov 4, 2004, in forum: ASP .Net
    VB Programmer
    Nov 4, 2004
  3. kingski
  4. Bo Peng
    Erik Max Francis
    Dec 19, 2005
  5. Martin RAYROLE

    testing the availability of a font

    Martin RAYROLE, Nov 28, 2003, in forum: Javascript
    Martin RAYROLE
    Dec 4, 2003