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