HELLO,

I want to write some error handling code in my asp page for when a SQL database is unavailable or when a table is locked.

1. What's the best way of checking if SQL server is running. Should I use object.state to determine if the connection is open.
2. How can I cater for instances where a SQL table is locked.

Thanks,
Cassandra

Cass

on error resume next

set conn=server.createObject("ADODB.connection")
conn.connectionString="Provider=SQLOEDB..."
conn.open

'If the connection has any problem, the Err object contains the corr error no.
if Err.number<>0 then
   response.write Err.description
   .......
end if


-------
Rajani