SP from SQL Server 2005 is not returning records in recordset (VB6)

SP from SQL Server 2005 is not returning the records in recordSet (VB6) recored return are -1. If access the recors using query and through record set, record set are filli开发者_如何学运维ng with records. Same connection string is used. I chek properly and there is no issue in code written for command object, then what is the wrong?

---

Make sure your CursorLocation property on your recordset is set to adUseClient

Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic