When you try to open an ActiveX Data Objects (ADO) recordset that a stored procedure populates, the recordset does not open if the stored procedure returns a high-severity error. If you try to access the value, you receive one of the following error messages:
NOTE: The message that you receive depends on factors such as the Microsoft Data Access Components (MDAC) version and the cursor location.
Current provider does not support returning multiple recordsets from a single execution.
-or-
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
-or-
Application-defined or object-defined error.
-or-
Object or provider is not capable of performing requested operation.
-or-
An unknown error has occurred.