Recordsets and stored procedures

[iandarbyshire]

I've got a ADO connection to a SQL server database, where a stored procedure is returning the data correctly (I know its worked as I can pull the data back from the first record). However the recordcount is -1 and if I try to move through the recordset e.g

rs.movelast
rs.movefirst

it crashes.

How do you pull back the whole recordset?

Thanks

[Anakim]

I use the following syntax to call SPROCs

    rsOrders.Open "exec stored_proc" & lsParams, moDB, adOpenStatic

where moDB is the ADODB database connection. This does allow me to move through the recordset with no problems. In this instance I only move forward through the recordset as it's a report which is being generated and thus to move dynamically around isn't an issue.

Not really sure if this is of any help for you!

[ghoff12]

I am getting the same problem.


Did anyone ever figure out how to solve it?

[ghoff12]

I figured out the problem

Just change the cursor location to be on the client and not the server