ADO Error Object

Error object

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

ADO generates an Error object for each error. Each Error object contains detailed information about a specific error and is stored in the Errors collection. To access these errors, you must refer to 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

Property

Property Description
Description Return an error description.
HelpContext Return the content ID of a topic in the Microsoft Windows help system.
HelpFile Return the complete path to the help file in the Microsoft Windows help system.
NativeError Return the error code from the provider or data source.
Number Return a unique number that can identify the error.
Source Return the name of the object or application that caused the error.
SQLState Return a 5-character SQL error code.