ADO Error Object






<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



ADO Error Object



❮ Previous
Next ❯



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



❮ Previous
Next ❯

Popular posts from this blog

Chat program with C++ and SFML

Function to Return a JSON Like Objects Using VBA Collections and Arrays

Will my employers contract hold up in court?