Take a look at the following KB articles:
BUG: NextRecordset Fails on Remoted or Disconnected Records
PRB: NextRecordset Fails When Called On a Disconnected Recordset
PRB: NextRecordset Never Returns Null or Nothing
Microsoft Visual Basic MVP
> I want to find out how to return multiple recordsets using stored procs
> on sql server and using the ADODB CONNECTION/COMMAND/RECORDSET objects.
> i have a stored proc which does 2 selects at the end. when i run using
> ISQL i see both the recordset.
> but i need to access these using ado. i can access the first one but i
> tried to access the second one using the nextrecorset method but it
> any suggestions/answers?
> Jitendra KHARE
> Sent via Deja.com http://www.deja.com/
> Before you buy.