RecordCount Returning -1

[stsuing]

I execute a SP that returns a record set. When I run it off one SQL server I get normal record count 0 - n records.

When I execute the same stored procedure off the production server it returns -1, even though I get records. MSDN say this is the problem.

The property returns -1 when ADO cannot determine the number of records

What would cause this.

 

[usesql]

i think when opening a connection u need to write this

rs.Open sqlstmt, Conn, adOpenStatic, adLockReadOnly
this returns the exact number of records
hope this helps

 

[stsuing]

Thanks the key was adLockReadOnly
I had adLockBatchOptimistic