Errors - How do YOU handle them?

I was curious how each of you handle database errors
instead of getting the OLEDB Micorsoft error screen. Do
you have a way of creating userfriendly errors for your
users or do you revert and let ADO handle those errors?

Thanks,

James

Re: Errors - How do YOU handle them?

Depends on the application. For some I use a custom 500 error handler, for
others I just use on error resume next. A trivial example:

set conn = CreateObject("ADODB.Connection")
on error resume next
conn.open "<...some connection string...>"
if err.number <> 0 then
response.write "Sorry, the database is not available."
response.end
end if
....

--
http://www.aspfaq.com/
(Reverse address to reply.)




"James" wrote in message
news:a4a401c4d71c$e7eea790$a401280a@phx.gbl...
> I was curious how each of you handle database errors
> instead of getting the OLEDB Micorsoft error screen. Do
> you have a way of creating userfriendly errors for your
> users or do you revert and let ADO handle those errors?
>
> Thanks,
>
> James