ADO Number Property

## ADO Tutorial

ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

## ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes
ADO Summary

## ADO Examples

ADO Examples

# 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

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE