Stored procs on SQL Server 7

[dave seddon]

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.

[raanand]

You can not use the same record set for different record selection unless you set it to nothing.
I think in your case you should try declaring two diferent record set.

Hope it helps