ADO-Trapping Oracle Errors

  • Thread starter Thread starter Alt255
  • Start date Start date
A

Alt255

Hello everyone I have tried looking and using the Error collection for
ADo Cennection, but I'm trying to capture a ORA-01017 error. The error
handler I use is only report the VBA error
-2147217843. Is this an actual VBA error that means "invalid login". I
would rather capture the Oracle error, is there a way in ADO to capture
the native Oracle Server Errors? ( outside of searching for the string
the err.description)
 
Hello everyone I have tried looking and using the Error collection
for ADo Cennection, but I'm trying to capture a ORA-01017 error. The
error handler I use is only report the VBA error
-2147217843. Is this an actual VBA error that means "invalid login".
I would rather capture the Oracle error, is there a way in ADO to
capture the native Oracle Server Errors? ( outside of searching for
the string the err.description)
Click to expand...

Are you using the VB(A) error object, or looping the the errors
collection of ADO?

See for instance http://support.microsoft.com/kb/167957/EN-US/ or look
up the Errors Collection in the documentation.
 
Back
Top