ADOCE errors occur when the methods and properties of the ADOCE control are used improperly, such as trying to update a read-only recordset.
The following table shows the ADO error values.
Constant | Value | Description |
adErrInvalidArgument | 3001 | The application is using parameters that are of the wrong type, out of acceptable range, or in conflict with one another. |
adErrNoCurrentRecord | 3021 | 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 | The operation requested by the application is not allowed in this context. |
adErrFeatureNotAvailable | 3251 | The operation requested by the application is not supported by the provider. |
adErrItemNotFound | 3265 | ADOCE cannot find the object in the collection corresponding to the name or ordinal reference requested by the application. |
adErrObjectNotSet | 3420 | The object referenced by the application no longer points to a valid object. |
adErrDataConversion | 3421 | The application is using a value of the wrong type for the current operation. |
adErrObjectClosed | 3704 | The operation requested by the application is not enabled if the object is closed. |
adErrObjectOpen | 3705 | The operation requested by the application is not enabled if the object is open. |
adErrProviderNotFound | 3706 | ADO could not find the specified provider. |
adErrInvalidConnection | 3709 | The connection string specified is invalid. |
The following code example sets the constants for the ADO errors.
Const adErrInvalidArgument = 3001
Const adErrNoCurrentRecord = 3021
Const adErrIllegalOperation = 3219
Const adErrFeatureNotAvailable = 3251
Const adErrItemNotFound = 3265
Const adErrObjectNotSet = 3420
Const adErrDataConversion = 3421
Const adErrObjectClosed = 3704
Const adErrObjectOpen = 3705
Const adErrProviderNotFound = 3706
Const adErrInvalidConnection = 3709