In addition to the provider errors that are described in the Error object and Errors collection, ADO itself can return errors to the exception-handling mechanism of your run-time environment. Use your programming language's error trapping mechanism, such as the On Error statement in Microsoft® Visual Basic®, to trap and handle the following errors. Both decimal and hexadecimal error code values are shown.
Constant name | Number | Description |
adErrInvalidArgument | 3001 0x800A0BB9 |
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. |
adErrNoCurrentRecord | 3021 0x800A0BCD |
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. |
adErrIllegalOperation | 3219 0x800A0C93 |
The operation requested by the application is not allowed in this context. |
adErrInTransaction | 3246 0x800A0CAE |
The application cannot explicitly close a Connection object while in the middle of a transaction. |
adErrFeatureNotAvailable | 3251 0x800A0CB3 |
The operation requested by the application is not supported by the provider. |
adErrItemNotFound | 3265 0x800A0CC1 |
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application. |
adErrObjectInCollection | 3367 0x800A0D27 |
Can't append. The object is already in the collection. |
adErrObjectNotSet | 3420 0x800A0D5C |
The object referenced by the application no longer points to a valid object. |
adErrDataConversion | 3421 0x800A0D5D |
The application is using a value of the wrong type for the current operation. |
adErrObjectClosed | 3704 0x800A0E78 |
The operation requested by the application is not allowed if the object is closed. |
adErrObjectOpen | 3705 0x800A0E79 |
The operation requested by the application is not allowed if the object is open. |
adErrProviderNotFound | 3706 0x800A0E7A |
ADO could not find the specified provider. |
adErrBoundToCommand | 3707 0x800A0E7B |
The application cannot change the ActiveConnection property of a Recordset object with a Command object as its source. |
adErrInvalidParamInfo | 3708 0x800A0E7C |
The application has improperly defined a Parameter object. |
adErrInvalidConnection | 3709 0x800A0E7D |
The application requested an operation on an object with a reference to a closed or invalid Connection object. |