Ado Help

[satishbeh]

I am having a problem using ADO. Sometimes when I open a recordset using ADO I get the recordcount as -1. I open a recordset in the following way:
rs.open "select * from account",cn,<adopendynamic> or <adopenstatic> ,adlockoptimistic
when I check the recordcount it shows -1. There are records in the recordset.
As far as I know, whenever records are returned in the recordset the recordcount property contains for the total count of records.

Whenever it shows -1, I am not able to use the properties in the recordset
i.e. Recordcount, movenext, movefirst etc. etc.
What could be the problem. Do you have any idea.

Regards,
Satish:

[Cimperiali]

Recordsets returned might not be of the expected type on serverside cursors.
It is not all in the hands of the developer: when you ask for a
dynamic or static recordset, the Provider might not be able to
retrive it that way - it has to deal with the Db...Unless you use a clientside cursor:
TRy
CursorLocation = adUseClient