>Hi, I am using a Data Connection to an SQL server, so I use a data command and a recordset too. When I open my recordset, the recordcount properties is always set to -1, but when I use check the EOF and BOF properties, it tells me that I do have some records in my recordset. Can anyone tell me why the recordcount doens't correspond to the number of records in the recordset? I always use to check this properties while I was in ACCESS but it just doesn't seem to work with ASP

See:

http://www.aspfaq.com/show.asp?id=2193