I have a small 3 tier application which is running perfectly okay. I want to trap a network error occurs. For eg is someone pulls the network cable from the client machine i want to trap that error on connection, recordset objects.

Can anybody guide me as what is the best way of doing it.