ADO Error Object

Error Object

The ADO Error object contains insights regarding information get to mistakes that have been produced amid a single operation. 

ADO creates one Error object for every mistake. Every Error object contains subtleties of the particular mistake, and are put away in the Errors accumulation. To get to the mistakes, you should allude to a particular connection.

To circle through the Errors collection:

for each objErr in objConn.Errors
  response.write("Description: ")
  response.write(objErr.Description & "<br>")
  response.write("Help setting: ")
  response.write(objErr.HelpContext & "<br>")
  response.write("Help record: ")
  response.write(objErr.HelpFile & "<br>")
  response.write("Native mistake: ")
  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 a mistake description
HelpContext Returns the setting ID of a theme in the Microsoft Windows help system
HelpFile Returns the full way of the assistance record in the Microsoft Windows help system
NativeError Returns a blunder code from the supplier or the information source
Number Returns a one of a kind number that recognizes the error
Source Returns the name of the item or application that created the error
SQLState Returns a 5-character SQL blunder code