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.