I am calling a stored proc on SQL Server 7 from VB6 using ADO. I can get the procedure to fire and return a recordset containing the resultant rows, but as soon as I try to assign the returned recordset to another recordset, I get an error with Object variable or With Block variable not set.

I have declared a new instance of the recordset trying to copy into but still doesn't work. Also set cursor as client side. Provider=MSDASQL

If I submit the same SQL for execution on the server, I can pass the recordset with no problems.

Any help or ideas appreciated.