HOME

ADO Tutorial
ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO SQL
ADO Demo

ADO Objects
ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream

Examples
ADO Examples
Download XMLSpy here
Please visit our sponsors !

The Number Property

Back

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

Back

Jump to: Top of Page or HOME or Printer Friendly Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

Validate How we converted to XHTML Validate

ASPHits
Active Server Pages Resource Web Site


Your own Web Site?

Read W3Schools
Hosting Tutorial


$15 Domain Name
Registration
Save $20 / year!


Advertise
at W3Schools

Only 0.5 CPM


SELECTED LINKS

University Online
Master Degree
Bachelor Degree

Web Software

The Future of
Web Development

Jobs and Careers

Web Security
Web Statistics
Web Standards


PARTNERS

W3Schools
TopXML
VisualBuilder
XMLPitstop
DevelopersDex
DevGuru
Programmers Heaven
The Code Project
Tek Tips Forum
ZVON.ORG
TopXML Search