ADO Error Object

Error Object

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

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

 

ADO Error

Login
ADS CODE