Table of contents
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 Examples ADO Examples Exam ADO Exam

Selected Reading
Web Statistics Web Glossary Web Hosting Web Quality W3Schools Tutorials W3Schools Forum Helping W3Schools

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

The tools you need to build your web project!

Ektron CMS400.NET Version 7.6 delivers all of the flexibility and features you need to deploy the Web site you want, quickly and efficiently.

learn more...

6 ways to take your site to the next level with Ektron:

	Create site stickiness through social networking. Keep it personal, relevant and interactive and they'll come back for more.
	Keep it open. Your site needs to be ready and able to connect to outside services. Ektron's open API gives you maximum flexibility.
	Streamline content and document management. Users need to quickly and intuitively find and add information.
	Empower your content authors. Reduce IT bottlenecks by allowing business users to create and edit Web content and forms.
	Climb to the top of search rankings. SEO tools, URL aliasing and eCommerce for your digital marketing strategy
	Add powerful Web 2.0 tools like blogs, wikis, forums, geo-mapping, rating systems and RSS feeds easily.

See why there are 20,000+ Ektron integrations worldwide.
Request an INSTANT DEMO or download a FREE TRIAL today.

WEB HOSTING
Password Protect Your Web Pages
$15 Domain Name Registration Save $20 / year!
Buy UK Domain Names Register Domain Names
Cheap Domain Names Cheap Web Hosting
Best Web Hosting
PHP MySQL Hosting
Top 10 Web Hosting
UK Reseller Hosting
Web Hosting
FREE Web Hosting

WEB BUILDING
Website Templates Flash Templates Website Builder Internet Business Opportunity
Custom Programming
FREE Trial or Demo Web Content Manager Forms,Web Alerts,RSS
Download XML editor
FREE Flash Website
FREE Web Templates

EDUCATION
US Web Design Schools
HTML Certification
JavaScript Certification
XML Certification
PHP Certification
ASP Certification

HOME or Top of Page		Printer Friendly
W3Schools is for training only. We do not warrant the correctness of its content. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy. Copyright 1999-2009 by Refsnes Data. All Rights Reserved.