Professional Web Applications Themes

Testing for SQL Availability in ASP - ASP Database

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

  1. #1

    Default Testing for SQL Availability in ASP

    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!




    ccg Guest

  2. #2

    Default Re: Testing for SQL Availability in ASP

    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"


    Bob Barrows [MVP] Guest

  3. #3

    Default Re: Testing for SQL Availability in ASP

    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!
    Bullschmidt Guest

Similar Threads

  1. Template availability
    By Double Design webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 2
    Last Post: December 29th, 08:38 PM
  2. JDK 1.4.2 Availability on AIX5L ?
    By mikeyw in forum AIX
    Replies: 2
    Last Post: August 20th, 03:20 PM
  3. Filter Availability
    By Alex Kotler in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 12
    Last Post: August 6th, 01:01 AM
  4. Cookie availability
    By Robert Scheer in forum ASP
    Replies: 1
    Last Post: August 4th, 04:49 PM
  5. Panther Availability?
    By claudel in forum Mac Applications & Software
    Replies: 3
    Last Post: June 25th, 08:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139