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. Object already in 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. |