The ADO Error object provides the specific detailsor it explain about each ADO error. The ADO Error object contains detailed information about any data access errors, alert or warnings that have been generated during a single operation.
The ActiveX Data Object (ADO) Error object detects any error generated and provides a lot of informaton but the ADO Error object provides two additional properties with info direct from the data provider
ADO Error Object Properties
Property
Description
Description
A descriptive string associated with an error.
HelpContext
The help file topic associated with an error.
HelpContext, HelpFile
The help file associated with an error.
NativeError
The provider-specific error code for an error.
Number
The number that uniquely identifies an error.
Source
The name of the object or application that originally generated the error.
SQL State
The SQL state for a given error.
Each ActiveX Data Object(ADO) Error object represents a specific provider error, not an ADO error. ADO errors are exposed to the run-time exception handling mechanism.
To access the errors, we must refer first to a specific connection.
