I am using VB6.0 and Sql server 2000 for developing an application. My problem is i have written a stored proc for retreiving records from database and i am executing it from Vb. When i do
set recordset= cmd.execute and count the recorcount.

it gives me recordcount as -1 and when i use rs .find it says "rowset doen not support scrolling backward ".

I am using cursor and lock type as
rs.LockType = adLockBatchOptimistic
rs.CursorType = adOpenKeyset

what can be the solution for this.

thanks in advance

sumeet mittal