Hi Every one

I am getting a recordset object from SQL store Proc. here is my code...

rs.OPEN(cmd)

cmd is command object and all property is set in that. Now what exactly i have to set , like cursortype or any thing so i can get RECORDCOUNT > 0
rs has records in it but only RECORDCOUNT = -1.

( I do get result set from Store Proc.)

Thanks
Mihir