The numbers can be a positive decimal, a negative decimal, or a hexadecimal value, and are equivalent to the Windows API HRESULTS values. For a warning, the number property will be zero.
Remember that errors are reported by ADO, but that they can be generated by either ADO or the underlying provider (data source). If the error was generated by the provider, the Number property may be set to an unspecific error value, such as:
Constant
| Value
| Description
|
adErrBoundToCommand
| 3707
-2146824581
0x800A0E7B
| Cannot change the ActiveConnection property
|
adErrCannotComplete
| 3732
-2146824556
0x800A0E94
| Cannot complete operation
|
adErrCantChangeConnection
| 3748
-2146824540
0x800A0EA4
| New connection has different characteristics from one in use
|
adErrCantChangeProvider
| 3220
-2146825068
0x800A0C94
| Provider is different from one is use
|
adErrCantConvertvalue
| 3724
-2146824564
0x800A0E8C
| Data value cannot be converted
|
adErrCantCreate
| 3725
-2146824563
0x800A0E8D
| Data value cannot be set or returned due to wrong data type or insufficient resources
|
adErrCatalogNotSet
| 3747
-2146824541
0x800A0EA3
| Need a valid ParentCatalog
|
adErrColumnNotOnThisRow
| 3726
-2146824562
0x800A0E8E
| Record not in this field
|
adErrDataConversion
| 3421
-2146824867
0x800A0D5D
| Value has wrong type
|
adErrDataOverflow
| 3721
-2146824567
0x800A0E89
| Data value too large
|
adErrDelResOutOfScope
| 3738
-2146824550
0x800A0E9A
| URL to be deleted is out of scope
|
adErrDenyNotSupported
| 3750
-2146824538
0x800A0EA6
| Sharing restrictions not supported by provider
|
adErrDenyTypeNotSupported
| 3751
-2146824537
0x800A0EA7
| Requested sharing restriction not recognized by provider
|
adErrFeatureNotAvailable
| 3251
-2146825037
0x800A0CB3
| Cannot perform requested operation
|
adErrFieldsUpdateFailed
| 3749
-2146824539
0x800A0EA5
| Update failed, check Status property
|
adErrIllegalOperation
| 3219
-2146825069
0x800A0C93
| Operation not allowed
|
adErrIntegrityViolation
| 3719
-2146824569
0x800A0E87
| Data value violates integrity constraints
|
adErrInTransaction
| 3246
-2146825042
0x800A0CAE
| Cannot close Connection
|
adErrInvalidArgument
| 3001
-2146825287
0x800A0BB9
| Arguments are wrong type, out of range, or conflict
|
adErrInvalidConnection
| 3709
-2146824579
0x800A0E7D
| Calling a closed or invalid Connection
|
adErrInvalidParamInfo
| 3708
-2146824580
0x800A0E7C
| Invalid Parameter object information
|
adErrInvalidTransaction
| 3714
-2146824574
0x800A0E82
| Invalid transaction or not started
|
adErrInvalidURL
| 3729
-2146824559
0x800A0E91
| Invalid URL address
|
adErrItemNotFound
| 3265
-2146825023
0x800A0CC1
| Item not found in collection
|
adErrNoCurrentRecord
| 3021
-2146825267
0x800A0BCD
| At BOF, or EOF, or no record exists
|
adErrNotExecuting
| 3715
-2146824573
<0x800A0E83 | Operation not executing
|
adErrNotReentrant
| 3710
-2146824578
0x800A0E7E
| Operation cannot proceed while firing event
|
adErrObjectClosed
| 3704
-2146824584
0x800A0E78
| Cannot perform operation while closed
|
adErrObjectInCollection
| 3367
-2146824921
0x800A0D27
| Cannot append object already in collection
|
adErrObjectNotSet
| 3420
-2146824868
0x800A0D5C
| Invalid Object
|
adErrObjectOpen
| 3705
-2146824583
0x800A0E79
| Cannot perform operation while object is open
|
adErrOpeningFile
| 3002
-2146825286
0x800A0BBA
| Cannot open file
|
adErrOperationCancelled
| 3712
-2146824576
0x800A0E80
| User cancelled operation
|
adErrOutOfSpace
| 3734
-2146824554
0x800A0E96
| Out of memory
|
adErrPermissionDenied
| 3720
-2146824568
0x800A0E88
| Permission denied to write to field
|
adErrPropConflicting
| 3742
-2146824546
0x800A0E9E
| Property values conflict with each other
|
adErrPropInvalidColumn
| 3739
-2146824549
0x800A0E9B
| Cannot apply property to field
|
adErrPropInvalidOption
| 3740
-2146824548
0x800A0E9C
| Attribute property invalid
|
adErrPropInvalidValue
| 3741
-2146824547
0x800A0E9D
| Invalid property value
|
adErrPropNotAllSettable
| 3743
-2146824545
0x800A0E9F
| Cannot set property or read-only
|
adErrPropNotSet
| 3744
-2146824544
0x800A0EA0
| Optional property value not set
|
adErrPropNotSettable
| 3745
-2146824543
0x800A0EA1
| Read-only property cannot be set
|
adErrPropNotSupported
| 3746
-2146824542
0x800A0EA2
| Property not supported by provider
|
adErrProviderFailed
| 3000
-2146825288
0x800A0BB8
| Provider failed to perform operation
|
adErrProviderNotFound
| 3706
-2146824582
0x800A0E7A
| Cannot find provider
|
adErrReadFile
| 3003
-2146825285
0x800A0BBB
| Cannot read file
|
adErrResourceExists
| 3731
-2146824557
0x800A0E93
| Use adCopyOverwite to replace object that already exists
|
adErrResourceLocked
| 3730
-2146824558
0x800A0E92
| Object is locked until processing completed
|
adErrResourcesOutOfScope
| 3735
-2146824553
0x800A0E97
| Resource outside scope of current record
|
adErrSchemaViolation
| 3722
-2146824566
0x800A0E8A
| Data type or constraints conflict with data value
|
adErrSignMismatch
| 3723
-2146824565
0x800A0E8B
| Data value is signed and field data is unsigned
|
adErrStillConnecting
| 3713
-2146824575
0x800A0E81
| Operation cannot be performed until connection completed
|
adErrStillExecuting
| 3711
-2146824577
0x800A0E7F
| Cannot perform operation while executing
|
adErrTreePermissionDenied
| 3728
-2146824560
0x800A0E90
| Permissions prohibit accessing tree or subtree
|
adErrUnavailable
| 3736
-2146824552
0x800A0E98
| Operation failed and status unavailable
|
adErrUnsafeOperation
| 3716
-2146824572
0x800A0E84
| Cannot access data source in another domain
|
adErrURLDoesNotExist
| 3727
-2146824561
0x800A0E8F
| URL cannot be found
|
adErrURLNamedRowDoesNotExist
| 3737
-2146824551
0x800A0E99
| This record does not exist
|
adErrVolumeNotFound
| 3004
-2146824555
0x800A0E95
| Provider cannot find the URL of the storage device
|
adErrWriteFile
| 3004
-2146825284
0x800A0BBC
| Failed to write to file
|
adWrnSecurityDialog
| 3717
-2146824571
0x800A0E85
| Not used
|
adWrnSecurityDialogHeader
| 3718
-2146824570
0x800A0E86
| Not used
|