SQL Server Error

Hey,

Hope someone can help me. I'm new to this whole ASP thing so i was wondering if anyone with more experience can help me.

I have an asp page that connects to a SQL Server database and logs information. Everything is working fine but if I stop SQL Server the application keels over. What i want to be able to do is to log the information to the database if everything is fine (connection etc) but if there is any problem like sql server is stopped then i want it to display that there was a problem loggin the information without the whole thing keeling over.

Any help would be grately appreciated!
Thanks

I've sorted it out myself with a series of error number checks and by using On Error Resume Next before Conn.open