err.number vs objconn.errors.count

[blexman]

What is exactly the difference in use ?

I know err.number needs the On Error Resume Next statement at the top of the ASP page but does objConn.error also need this as well ?

I have code like this that checks for database errors:

IF objConn.Errors.count > 0 THEN
For Each errLoop In objConn.Errors
response.write "sqlstate---> "
response.write errLoop.SQLState
response.write &quot;<br>&quot;
Next
END IF

..should I be using err.number<>0 instead ?

thanks