Testing SERVER Status

[NikP]

Hi I have an ASP site which is runnig of an NT Server however it uses an ODBC connection to connect to another server to access the dB....the server with the dB sometimes is down....and therefore I get an error on the page saying SERVER NOT FOUND etc....How can i detect if the server with the dB is runing so I can put a page up which tells the users that the site is down for while etc....

Any help would be great thanks

Nik

 

[JohnYingling]

No experience with DB on another server but can't you use

DIM strResponse
ON ERROR RESUME NEXT
    objConn.Open(.....)
    IF ERR > 0 THEN
        strResponse = Err.Description
    END IF
ON ERROR GOTO 0

http://WWW.VBCompare.Com

 

[link9]

Yes, and even to take it one step further, you could display your users a message like this:

DIM strResponse
ON ERROR RESUME NEXT
objConn.Open(.....)
IF ERR > 0 THEN
strResponse = Err.Description
response.write(&quot;<h1 align=center>Sorry, the site is down right now</h1>&quot
response.end
END IF
ON ERROR GOTO 0

so that if an error occurs, you just show them a message and stop output right there...