How to Trap Database Errors In ASP?

Answer 1

I assume you mean asp.net and not classic.
Basically
use try catch

try
{
your db code
}
catch (Exception e) // note I don't know which type of connection you are using since you know this you can use sqlException, OracleException, OleDB etc etc....
{
// deal with exception
}
finally
{
// do all cleanup probably want to close the connection object you opened
}

Answer 2

Try
'Your codes here
Catch ex as Exception
Response.Write(ex.message)
End Try

Answer 3

put your code to do whatever you want in a TRY CATCH block and catch sql exceptions .....

TRY
your code
CATCH SQLEXCEPTION s AS
code for handling exception
END TRY