When using ADO, we often use try {//} catches in the program; ........ ErrorMessage () ;......
To capture the exception information of ADO, but E.ErrorMessage () output is often some error numbers, for example: Idispatch Error # 3748 is what we still can't understand which aspects result in an exception
Let's give the error code in ADO and the corresponding description information, I hope to help everyone!
3707 Applications cannot change the ActiveComnection property of the Recordset object, as a Command object as its source 3732 Cannot completing action 3748 Cannot change connection 3220 Cannot change the provider 3724 Cannot Creating a resource 3747 Category No setting So action Can't perform 3726 This line There is no specified column 3421 For the current application, the application uses the value of the error type 3721 data beyond the range of the given data type 3738 cannot delete resources, which exceeds the allowable range 3750 cannot set DENY privileges because the provider is not Support 3751 Provider Unsupported DENY Type 3251 Provider does not support this application request 3749 Fields collection DPDATE method failed 3219 Do not allow application requests in this environment 3719 3719 to operate 3719 due to violation of data integrity, operation failure 3246 In a transaction, the application cannot explicitly shut down the parameter type error used by the Connection object 3001 application, which may be out of the range or use other types of conflicts 3709 applications to use a reference for an operation of an object, and the reference points to A closed or invalid Connection object 3708 application is not appropriately defined a parameter object 3714 Transaction invalid 3729 Provided URL invalid 3265 ADO does not discover the object 3021 BoF and EOF in the collection, or the current record has been Delete, and the application's request operation requires the current record 3715 operation not in the execution process 3710 operation cannot be re-executed 3704 If the object is closed, the application request is not allowed 3367 Objects already in the collection, cannot append 3420 by the application referenced by the application Objects no longer point to valid object 3705 If the object has been turned on, the application request is not allowed to operate 3002 When the requested file is turned on, an error 3712 operation is canceled 3734 because the server does not have enough space to complete the operation, the operation failed 3720 The user does not have enough permission to complete the operation, the operation failed 3742 Set this property and other attribute conflicts 3739 For the selected column, this attribute is invalid 3740 provides an invalid selection 3741 to the attribute provides an invalid value 3743 not all Attributes can be set 3744 Attributes Not set 3745 Property Unable to be set 3746 Attributes Not supported 3000 Provider Execution Action Failed 3706 ADO Can't find the specified provider 3003 Read the specified file Error 3731 Resources already exist 3730 resources Lock 3735 resource beyond range 3722 Action violates mode 3723 Expression contains mismatched symbol 3713 operations Still in connection 3711 operation Still executing 3728 Permissions without viewing directory tree 3736 Command Unavailable 3716 In this case running unsafe 3727 URL does not exist 3737 In named line URL There is no 3733 file version information has no 3004 write file with error 3717 Operation leads an security dialog 3718 operation to lead a security dialogue
Constant Name Decimal No. Hexadecimal Number Description
AderrinvaliDargument 30010x800A0BB9 The application used by the application is incorrect, exceeds an acceptable range or conflicts with other parameters.
AderrnocurrentRecord 30210x800A0BCDBOF or EOF is true, or the current record has been deleted. The operation requested by the application requires the current record.
ADERRILLEGALOPERATION 32190X800A0C93 The application request is not allowed to appear in this context ADERRINTRANSACTION 32460X800A0CAE in transaction cannot explicitly shut down the Connection object.
The ADERRFEATATAVAILABLE 32510X800A0CB3 provider does not support the operation of the application request.
AderriteMNotfound 32650x800A0CC1ADO cannot find an object in a collection corresponding to the name or order reference corresponding to the application request.
AderrobjectIncollection 33670x800A0D27 is unable to append, the object is already in the collection.
The ADERROBJECTNOTSET 3420 0x800A0D5C application references are no longer pointing to valid objects.
The ADERRDATACONVERSION 34210X800A0D5D application uses a value type that does not meet the current operation.
ADERROBJECTCLOSED 37040X800A0E78 If the object is closed, the application request is not allowed.
ADERROBJECTOPEN 37050X800A0E79 If an object is open, the application request is not allowed.
AderroviderNotfound 37060x800a0e7aado does not find the specified provider.
The AderrboundTocommand 37070x800A0E7B application cannot use the Command object to change the ActiveConnection property of the Recordset object to its source data.
The AderrinvalidParaminfo 37080x800A0E7C application erroneously defines Parameter objects.
The ADERRINVALIDCONNECTION 37090X800A0E7D application requests the operation of the object by reference to a closed or invalid Connection object.
Some of the above sections may have some repetition, and the second part is less detailed, and it can be contrasted!
