ado| errors In addition to the provider errors that are described in the Error object and the Errors collection, ADO itself returns errors to the exception handling mechanism of the run-time environment. The following errors can be captured and handled using error-trapping mechanisms in the programming language, such as the On Error statement in Microsoft®visual basic®. The following table displays both decimal and hexadecimal error code values.
Constant Name Number description
Aderrinvalidargument 3001
0x800A0BB9
The parameter used by the application is of a wrong type, is out of an acceptable range, or conflicts with other parameters.
Aderrnocurrentrecord 3021
0x800a0bcd
BOF or EOF is True, or the current record has been deleted. The operation requested by the application requires the current record.
Aderrillegaloperation 3219
0x800a0c93
The operation requested by the application is not allowed to appear in this context
Aderrintransaction 3246
0x800a0cae
An application cannot explicitly close the Connection object in a transaction.
Aderrfeaturenotavailable 3251
0x800a0cb3
The operation requested by the application is not supported by the provider.
adErrItemNotFound 3265
0x800a0cc1
ADO cannot find an object in the collection that corresponds to the name or order reference of the application request.
Aderrobjectincollection 3367
0x800a0d27
Cannot append, the object is already in the collection.
Aderrobjectnotset 3420 0x800a0d5c An object referenced by an application no longer points to a valid object.
Aderrdataconversion 3421
0x800a0d5d
The application used a value type that does not conform to the current operation.
Aderrobjectclosed 3704
0x800a0e78
If the object is closed, the operation requested by the application is not allowed.
Aderrobjectopen 3705
0x800a0e79
If the object is open, the operation requested by the application is not allowed.
Aderrprovidernotfound 3706
0x800a0e7a
ADO could not find the specified provider.
Aderrboundtocommand 3707
0x800a0e7b
The application cannot use the Command object to change the Recordset object's ActiveConnection property to its source data.
Aderrinvalidparaminfo 3708
0x800a0e7c
The application incorrectly defines the Parameter object.
Aderrinvalidconnection 3709
0x800a0e7d
An application requests an action on an object by referencing a closed or invalid Connection object.
Continue to add:
Error codes and descriptions
3707 application cannot change the Activecomnection property of the Recordset object to use the Command object as its source
3732 cannot complete the action
3748 cannot change the connection
3220 Cannot change provider
3724 cannot convert a value cannot create a resource
3747 category is not set so action cannot be performed
3726 The specified column does not exist in this line
3421 the application uses the wrong type of value for the current application
3721 data exceeds the range of the given data type
3738 cannot delete resource, this is beyond the allowable range
3750 cannot set deny permission because the provider does not support
3751 The requested deny type is not supported by the provider
3251 provider does not support the operation requested by this application
Dpdate method of 3749 Fields collection failed
3219 actions requested by the application are not allowed in this environment
3719 operation failed because of data integrity violation
3246 in a transaction, an application cannot explicitly close the Connection object
3001 application uses a wrong parameter type that may be out of range or conflict with other types
3709 the application requested an action on an object using a reference that points to a closed or invalid connection object
3708 The application inappropriately defines a parameter object
3714 Transaction is invalid
3729 The URL provided is invalid
3265 ADO found no objects in the collection
One of the 3021 BOF and EOF is true, or the current record has been deleted, and the application's request operation requires the current record
3715 operation is not in the process of execution
3710 operation cannot be performed again
3704 the action requested by the application is not allowed if the object is closed
The 3367 object is already in the collection and cannot be appended
3420 objects referenced by the application no longer point to a valid object
3705 if the object is open, the operation requested by the application is not allowed
3002 An error occurred while opening the requested file
3712 Operation canceled
3734 because the server does not have enough space to complete the operation, the operation failed
3720 operation failed because the user does not have sufficient permissions to complete the operation
3742 set this property to cause conflicts with other properties
3739 This property is not valid for the selected column
3740 provides an invalid selection for the attribute
3741 provides an invalid value for the property
3743 not all attributes can be set
3744 property is not set
3745 property cannot be set
3746 property is not supported
3000 the provider failed to execute the requested action
3706 ADO cannot find the specified provider
3003 Error while reading the specified file
3731 Resources already exist
3730 Resources are locked
3735 Resource Beyond Range
3722 action violates the pattern.
3723 expression contains mismatched symbols
3713 operation still in connection
3711 operation still in execution
3728 No permissions to view the directory tree
3736 Command not available
3716 not safe to run in this case
3727 URL does not exist
3737 the URL in the named row does not exist
3733 file version information not found
3004 Error writing file
3717 operation leads to a security conversation
3718 operation leads to a security conversation header
Extended ADO errors and their descriptions
-2147483647 Not implemented
-2147483646 Low Memory
-21,474,836,451 or more arguments are invalid
-2147483644 does not support such an interface
-2147483643 Invalid pointers
-2147483642 Invalid Handle
-2147483641 Operation terminated
-2147483640 an indeterminate error
-21,474,836,391 Access Rejection error
-2147483638 data necessary to complete the operation is no longer available
-2147467263 Not implemented
-2147467262 does not support such an interface
-2147467261 Invalid pointers
-2147467260 Operation terminated
-2147467259 an indeterminate error
-2147467258 Thread Local storage failed
-2147467257 failed to get shared memory allocation program
-2147467256 Get memory allocation program failed
-2147467255 cannot initialize cache for class
-2147467254 failed to initialize RPC service
-2147467253 Unable to set thread local storage channel control
-2147467252 cannot allocate thread local storage channel control
-2147467251 user supplied memory allocation program is not acceptable
-2147467250 OLE service mutex already exists
-2147467249 OLE service file mappings already exist
-2149467248 cannot map the OLE service's file View
-2147467247 failed to start OLE service
-2147467246 attempts to invoke CoInitialize again in the single-threaded model
-2147467245 requires a remote activation, but does not allow
-2147467244 requires a remote activation, but the supplied server name is invalid
-The security ID of the 2147467243 class run configuration is different from the caller
-2147467242 DDE windows required to use the OLE1 service are disabled
-2147467241 runas specified must be a domain name \ username or just a user name
-2147467240 service process could not start, possibly incorrect path name
-2147467239 The service process cannot start when the identity is configured, the pathname may be incorrect or invalid
-2147467238 The service process could not be started because the configuration ID is incorrect. Check User name and password
-2147467237 does not allow customers to start this server
-2147467236 server that provides this service does not start
-2147467235 This computer cannot communicate with other computers provided by the server
-2147467234 server does not respond after startup
-2147467233 the registration information for the server is inconsistent or incomplete
-2147467232 registration information for this interface is inconsistent or incomplete
-2147467231 does not support an attempt to perform an action
-2147418113 Catastrophic failure
-21,470,248,911 Access Rejection error
-2147024890 Invalid Handle
-2147024882 Low Memory
-21,470,248,091 or more arguments are invalid
