Pagecount Recordset Property

Hi,

I am attempting to use the pagecount property of my recordset on an asp page.

The return value I get is '-1' which suggests an error somewhere.

Can anyone help?

Thank you in advance.

RecordSet.Open str,3,3

I had already used the cursortype and location that you suggested.

I am beginning to think that it is a problem with a driver reference. How can I reference a specific driver on an ASP page?

I've tried:
<!--#include file "\gdsdrivers\msado15.dll"-->

but that just reads the driver like a text file.

Any ideas?

It seems that I have never seen such a problem....
If you just want to get the rs.count ,thy this code:

set a=server.createobject("adodb.recordset")
sql_a="select count(id) from book where type=0"
set a=conn.execute(sql_a)
response.write a(0)
a.close
set a=nothing

OK?
BTW,the #include command will link the file what you assigned and run it as ASP code.So the included file must be TXT format.
So when you include .dll file ,the system will treat it as ASP code.

I've made a little progress.

The .dll file has now been included as metadata, but that doesn't help.

Something somewhere on my system is old and means that my recordset doesn't support the PageCount property.

ADO 2.6 is out. Why not use it instead of 1.5