ADO ErrorObject

Error Object

The ADO Error object contains detailed information about data access errors related to a single operation (involving the provider).

ADO creates an Error object for each error. Each Error object contains detailed information about a specific error, and Error objects are stored in the Errors collection. To access these errors, you must reference a specific connection.

Loop through the Errors collection:

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

Syntax

objErr.property

Properties

Property Description
Description Returns a description of the error.
HelpContext Returns the content 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 the error code from the provider or 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.
Other Extensions