connection error

<i><b>Originally posted by : venkat (venkat_karnati@hotmail.com)</b></i><br />Hi guys,<br />We are developing a web site using ASP and SQL server.In our home page our registered users can login to the system by using their username and password.when user types in username and password<br />and clicks the GO button, this two values are validated in the database and allows the user to login to the system.If this two values are incorrect, we are displaying a error message below this two input boxes.Till this point every thing is ok and smooth.<br />Our database server and web server are located at different place than the development center.If the SQL server is down for some reason, we could not able to display any error message to our users.<br />I want to catch this event by using ADO object.<br />Can any body tell me, is there any methods in ADO to catch the connection between front end and back end.<br />I want to display the error message in a alert box.<br /><br />thanks in advance<br />veera<br />

<i><b>Originally posted by : </b></i><br /><br /><br /><br />------------<br />venkat at 1/17/2001 10:06:06 AM<br /><br />Hi guys,<br />We are developing a web site using ASP and SQL server.In our home page our registered users can login to the system by using their username and password.when user types in username and password<br />and clicks the GO button, this two values are validated in the database and allows the user to login to the system.If this two values are incorrect, we are displaying a error message below this two input boxes.Till this point every thing is ok and smooth.<br />Our database server and web server are located at different place than the development center.If the SQL server is down for some reason, we could not able to display any error message to our users.<br />I want to catch this event by using ADO object.<br />Can any body tell me, is there any methods in ADO to catch the connection between front end and back end.<br />I want to display the error message in a alert box.<br /><br />thanks in advance<br />veera<br />