Thuộc tính số ADO
❮ Tham chiếu đối tượng lỗi hoàn chỉnh
Thuộc tính Number trả về một giá trị dài là một số duy nhất có thể nhận một trong các giá trị ErrorValueEnum . Con số mô tả lỗi do ADO tạo ra. Nếu lỗi do nhà cung cấp tạo ra thì thuộc tính này có thể được đặt thành giá trị lỗi không xác định.
Các con số tương đương với các giá trị HRESULTS của API Windows.
Cú pháp
lngErrorNumber=objErr.Number Ví dụ
<%
for each objErr in objConn.Errors
response.write("<p>")
response.write("Description: ")
response.write(objErr.Description & "<br>")
response.write("Help context: ")
response.write(objErr.HelpContext & "<br>")
response.write("Help file: ")
response.write(objErr.HelpFile & "<br>")
response.write("Native error: ")
response.write(objErr.NativeError & "<br>")
response.write("Error number: ")
response.write(objErr.Number & "<br>")
response.write("Error source: ")
response.write(objErr.Source & "<br>")
response.write("SQL state: ")
response.write(objErr.SQLState & "<br>")
response.write("</p>")
next
%> Giá trị ErrorValueEnum
| Constant | Value | Description |
|---|---|---|
| adErrBoundToCommand | 3707 -2146824581 0x800A0E7B | Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source |
| adErrCannotComplete | 3732 -2146824556 0x800A0E94 | Server cannot complete the operation |
| adErrCantChangeConnection | 3748 -2146824540 0x800A0EA4 | Connection was denied |
| adErrCantChangeProvider | 3220 -2146825068 0X800A0C94 | Supplied provider is different from the one already in use |
| adErrCantConvertvalue | 3724 -2146824564 0x800A0E8C | Data value cannot be converted |
| adErrCantCreate | 3725 -2146824563 0x800A0E8D | Data value cannot be set or retrieved |
| adErrCatalogNotSet | 3747 -2146824541 0x800A0EA3 | Operation requires a valid ParentCatalog |
| adErrColumnNotOnThisRow | 3726 -2146824562 0x800A0E8E | Record does not contain this field |
| adErrDataConversion | 3421 -2146824867 0x800A0D5D | Application uses a value of the wrong type |
| adErrDataOverflow | 3721 -2146824567 0x800A0E89 | Data value is too large |
| adErrDelResOutOfScope | 3738 -2146824550 0x800A0E9A | URL of the object to be deleted is outside the scope of the current record |
| adErrDenyNotSupported | 3750 -2146824538 0x800A0EA6 | Provider does not support sharing restrictions |
| adErrDenyTypeNotSupported | 3751 -2146824537 0x800A0EA7 | Provider does not support the kind of sharing restriction |
| adErrFeatureNotAvailable | 3251 -2146825037 0x800A0CB3 | Object/Provider is not capable of performing requested operation |
| adErrFieldsUpdateFailed | 3749 -2146824539 0x800A0EA5 | Fields update failed |
| adErrIllegalOperation | 3219 -2146825069 0x800A0C93 | Operation is not allowed in this context |
| adErrIntegrityViolation | 3719 -2146824569 0x800A0E87 | Data value conflicts with the integrity constraints of the field |
| adErrInTransaction | 3246 -2146825042 0x800A0CAE | Connection object cannot be closed while in a transaction |
| adErrInvalidArgument | 3001 -2146825287 0x800A0BB9 | Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another |
| adErrInvalidConnection | 3709 -2146824579 0x800A0E7D | The connection cannot be used to perform this operation. It is either closed or invalid in this context |
| adErrInvalidParamInfo | 3708 -2146824580 0x800A0E7C | Parameter object is improperly defined |
| adErrInvalidTransaction | 3714 -2146824574 0x800A0E82 | Coordinating transaction is invalid |
| adErrInvalidURL | 3729 -2146824559 0x800A0E91 | URL contains invalid characters |
| adErrItemNotFound | 3265 -2146825023 0x800A0CC1 | Item cannot be found in the collection corresponding to the requested name or ordinal |
| adErrNoCurrentRecord | 3021 -2146825267 0x800A0BCD | Either BOF or EOF is True, or the current record has been deleted |
| adErrNotExecuting | 3715 -2146824573 0x800A0E83 | Cannot perform operation while not executing |
| adErrNotReentrant | 3710 -2146824578 0x800A0E7E | Cannot perform operation while processing |
| adErrObjectClosed | 3704 -2146824584 0x800A0E78 | Operation not allowed when the object is closed |
| adErrObjectInCollection | 3367 -2146824921 0x800A0D27 | Object is already in collection. Cannot append |
| adErrObjectNotSet | 3420 -2146824868 0x800A0D5C | Object is no longer valid |
| adErrObjectOpen | 3705 -2146824583 0x800A0E79 | Operation not allowed when the object is open |
| adErrOpeningFile | 3002 -2146825286 0x800A0BBA | Could not open file |
| adErrOperationCancelled | 3712 -2146824576 0x800A0E80 | Operation cancelled by the user |
| adErrOutOfSpace | 3734 -2146824554 0x800A0E96 | Cannot perform operation. Provider cannot obtain enough storage space |
| adErrPermissionDenied | 3720 -2146824568 0x800A0E88 | Permission denied when writing to the field |
| adErrProviderFailed | 3000 -2146825288 0x800A0BB8 | Provider failed to perform the operation |
| adErrProviderNotFound | 3706 -2146824582 0x800A0E7A | Provider cannot be found |
| adErrReadFile | 3003 -2146825285 0x800A0BBB | File could not be read |
| adErrResourceExists | 3731 -2146824557 0x800A0E93 | Cannot perform copy operation. Object already exists. Specify adCopyOverwrite to replace the object |
| adErrResourceLocked | 3730 -2146824558 0x800A0E92 | Object is locked by other processes |
| adErrResourceOutOfScope | 3735 -2146824553 0x800A0E97 | URL/Source outside scope of current record |
| adErrSchemaViolation | 3722 -2146824566 0x800A0E8A | Data value conflicts with data type or constraints |
| adErrSignMismatch | 3723 -2146824565 0x800A0E8B | Conversion failed because the data value is signed and the field data type is unsigned |
| adErrStillConnecting | 3713 -2146824575 0x800A0E81 | Cannot perform operation while connecting asynchronously |
| adErrStillExecuting | 3711 -2146824577 0x800A0E7F | Cannot perform operation while executing asynchronously |
| adErrTreePermissionDenied | 3728 -2146824560 0x800A0E90 | Permission denied accessing tree or subtree |
| adErrUnavailable | 3736 -2146824552 0x800A0E98 | Operation failed and the status is unavailable |
| adErrUnsafeOperation | 3716 -2146824572 0x800A0E84 | Cannot access data source on another domain |
| adErrURLDoesNotExist | 3727 -2146824561 0x800A0E8F | The URL does not exist |
| adErrURLNamedRowDoesNotExist | 3737 -2146824551 0x800A0E99 | Record does not exist |
| adErrVolumeNotFound | 3733 -2146824555 0x800A0E95 | Provider cannot locate the storage device. Make sure the URL is typed correctly |
| adErrWriteFile | 3004 -2146825284 0x800A0BBC | Failed when writing to file |
| adWrnSecurityDialog | 3717 -2146824571 0x800A0E85 | Not in use |
| adWrnSecurityDialogHeader | 3718 -2146824570 0x800A0E86 | Not in use |
❮ Tham chiếu đối tượng lỗi hoàn chỉnh
