I have created an ASP script that queries a SQL 7.0 Server that is running. This is a nice way to check my server. However if the SQL Server is turned off (down), then I receive a message:<BR><BR> Microsoft OLE DB Provider for ODBC Drivers error '80004005' <BR> [Microsoft][ODBC SQL Server Driver][Named Pipes]<BR> Specified SQL server not found. <BR><BR> /webapps/sqlpowerup.asp, line 198 <BR><BR>This is not too helpful, because I am trying to create a RED light GREEN light indicator to judge if the server is down. For instance: RED light if the SQL Server is down, and GREEN light if the SQL Server is up. I cannot seem to get the script to work if I am receiving the above error message. <BR><BR>Do you have any suggestion to how I can check to see if my SQL Server is up or down? I would appreciate any suggestion you have, for at this point I am quite at a loss for ideas. Thanks in advance for you help,<BR><BR>Kevin G. Verhoeven<BR><BR>P.S. Below is the code I use for the connection to the SQL Server:<BR><BR><%<BR>set myConnection = CreateObject("ADODB.Connection")<BR> myConnection.Open "DSN=MYSQLDATABASE;UID=sa"<BR> SQLQuery = "SELECT status FROM sysfiles"<BR> set RSTitleList = myConnection.Execute(SQLQuery)<BR>%><BR><BR> <TR> <BR> <TD ALIGN=left valign=top BGCOLOR="#99CCCC"><BR> <B>Status of SQL Server</b><BR> </TD><BR> </TR><BR><BR><% do while not RStitleList.EOF %><BR><BR> <TR><BR> <TD BGcolor ="f7efde" align=left valign=top><BR> <%=RStitleList("status")%><BR> </TD><BR> </TR><BR><BR><% RSTitleList.MoveNext%><BR><%loop %><BR><%myConnection.close%><BR><BR >Thanks!