ADO Error Numbers

[dlh]

What is the relationship between ADO error numbers & named constants as documented in the ADO Error Reference and the numbers accesible via VBA's Err object?

I've tried in particular raising an error by manually cancelling the logon to my external database, but instead of adErrOperationCancelled with Number = 3712, I'm seeing Err.Number = -2147217842.

[romperstomper]

See this MSKB article. In my experience, if the connection is not established initially, you won't get anything in the Errors collection, so your only recourse is to error handle as usual.

[dlh]

Valuable reading. Thanks for the link.

(I presume the original error # I saw wasn't an ADO error at all.)