No can do. You'll have to make separate calls to bring the data back. NextRecordset is only valid on direct connections with no disconnect or marshaling.

From the ADO help: "As long as there are additional results and the Recordset containing the compound statements is not disconnected or marshaled across process boundaries, the NextRecordset method will continue to return Recordset objects."

When you test it on your dev machine you have a direct connection and no marshaling.

Cheers,
Crescencio

>I'm getting an ADODB.Recordset error "3251: Current Provider does not support returning multiple recordsets from a single execution." when calling the NextRecordset method of the Recordset from MSSQL 2000.
>
>I don't get this error when I run this particular code on my development machine but when I deploy the app on all other machines I get this same error.
>
>I even tested on another machine with MDAC version 2.7 same as on my development machine but the same problem persists. Only difference now between the development machine and deployment machine is that the ActiveX DLL component actually returning the RS is located on the "Server" rather on the same machine as is the case with the development machine.
>
>Anyone run into a similar problem with a solution? TIA.