Error object ¶
ADO Error object contains details of data access errors related to a single operation involving a provider.
ADO will produce one for each error. Error object. Every one of them. Error object contains details of the specific error, and Error object is stored in the Errors assembly. To access these errors,you must reference a specific connection.
Loop traversal Errors collection:
<%
for each objErr in objConn.Errors
response.write(""
)
response.write("Description: ")
response.write(objErr.Description& "
")
response.write("Help context: ")
response.write(objErr.HelpContext & "
")
response.write("Help file: ")
response.write(objErr.HelpFile & "
")
response.write("Native error: ")
response.write(objErr.NativeError & "
")
response.write("Error number: ")
response.write(objErr.Number & "
")
response.write("Error source: ")
response.write(objErr.Source & "
")
response.write("SQL state: ")
response.write(objErr.SQLState & "
")
response.write("")
next
%>
Grammar ¶
objErr.property
Attribute ¶
Attribute | Description |
|---|---|
Description | Returns an error description. |
HelpContext | Returns the content ID of a topic in Microsoft Windows help system. |
HelpFile | Returns the full path to the help file in Microsoft Windows help system. |
NativeError | Returns the error code from the provider or data source. |
Number | Returns a unique number that identifies the error. |
Source | Returns the name of the object or application that caused the error. |
SQLState | Returns a 5-character SQL error code. |