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