OLEDBError Object

Remarks

The OLEDBError object is a member of the OLEDBErrors collection. If the specified OLE DB query runs without error, the OLEDBErrors collection is empty. The errors in the collection are indexed in the order in which they're generated by the OLE DB provider.

Example

Use OLEDBErrors(), where is the index number of the OLE DB error, to return a single OLEDBErrorobject. The following example displays the error description and the SqlStateproperty's value for the first error returned by the most recent OLE DB query.

Set objEr = Application.OLEDBErrors(1) MsgBox "The following error occurred:" & _ objEr.ErrorString & " : " & objEr.SqlState

See also:

• Excel Object Model Reference
• OLEDBError Object Members