Tutorials References Menu

ADO Number Property


❮ Complete Error Object Reference

The Number property returns a long value that is a unique number that can take one of the ErrorValueEnum values. The number describes the error generated by ADO. If the error was generated by the provider, this property may be set to an unspecific error value.

The numbers are equivalent to the Windows API HRESULTS values.


Syntax

lngErrorNumber=objErr.Number

Example

<%
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 Values

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

❮ Complete Error Object Reference