Proprietà numero ADO
❮ Completare il riferimento all'oggetto di errore
La proprietà Number restituisce un valore lungo che è un numero univoco che può accettare uno dei valori ErrorValueEnum . Il numero descrive l'errore generato da ADO. Se l'errore è stato generato dal provider, questa proprietà potrebbe essere impostata su un valore di errore non specifico.
I numeri sono equivalenti ai valori HRESULTS dell'API di Windows.
Sintassi
lngErrorNumber=objErr.Number
Esempio
<%
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
%>
ErrorValueEnum Valori
| 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 |
❮ Completare il riferimento all'oggetto di errore