ADO Error Object

ADO Error Object

ADO Error object contains details about data access errors that have been generated during a single operation.

ADO Error Object

  • ADO generates one Error object for each error. Each Error object contains details of the specific error, and are stored in the Errors collection. To access the errors, you must refer to a specific connection.
  • To loop through the Errors collection:

for each objErr in objConn.Errors
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>”)




Property Description
Description Returns an error description
HelpContext Returns the context ID of a topic in the Microsoft Windows help system
HelpFile Returns the full path of the help file in the Microsoft Windows help system
NativeError Returns an error code from the provider or the data source
Number Returns a unique number that identifies the error
Source Returns the name of the object or application that generated the error
SQLState Returns a 5-character SQL error code

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.