The ADO Error object contains the most recent data access error from the data provider.

Basic Usage

ADO provides an Error object that is similar to the Err object provided by VB/VBScript. The Err object detects any error generated and provides a lot of info but the ADO Error object provides two additional properties with info direct from the data provider.

Note that VBS is limited to On Error Resume Next, On Error Resume 0, and the Err object. See also my article on VB Debugging.

EG:

Set cnn1 = Server.CreateObject("ADODB.Connection")
On Error Resume Next
'Error may occur but resumes on next line with error handling:
If Err Then
    Response.Write "<p><b>VBScript Err Object:</b><br>" & _
        "-Number: "      & Err.Number & "<br>" & _
        "-Description: " & Err.Description & "<br>" & _
        "-Source: "      & Err.Source & "<br>" & _
        "-HelpFile: "    & Err.HelpFile & "<br>" & _
        "-HelpContext: " & Err.HelpContext & "</p>"
    'The Error object may return multiple errors:
    For i = 0 To cnn1.Errors.Count - 1
        Response.Write "<p><b>ADO Error Object:</b><br>" & _
            "-Number: "      & Err.Number & "<br>" & _
            "-Description: " & Err.Description & "<br>" & _
            "-Source: "      & Err.Source & "<br>" & _
            "-HelpFile: "    & Err.HelpFile & "<br>" & _
            "-HelpContext: " & Err.HelpContext & "<br>"
            "-SQLState: "    & Err.SQLState & "<br>" & _
            "-NativeError: " & Err.NativeError & "</p>"
    Next
End If

ADO resets the ADO Error collection before every ADO call on each Connection object, thus the Error collection will only have errors from the most recent call.

Properties, Methods, and Events

Properties Methods Events
  1. Description
  2. HelpContext
  3. HelpFile
  4. NativeError
  5. Number
  6. Source
  7. SQLState
None None


GeorgeHernandez.comSome rights reserved