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.