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