我在用recordset记录集的时候出现错误,用odbc打开数据库时,rs.absolutepage为-1
set conn=server.createobject("adodb.connection")
connstr="driver={microsoft access driver (*.mdb)};DBQ="&_
server.mappath("../data/tongxue.mdb")
conn.open connstr
set rs=server.createobject("adodb.recordset")
sqlstr="select * from guest order by date desc"
rs.open sqlstr,conn,3
rs.pagesize=10
而改为用以下ole连接时则正常
set conn=server.createobject("adodb.connection")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("../data/tongxue.mdb")
conn.open connstr
set rs=server.createobject("adodb.recordset")
sqlstr="select * from guest"
rs.open sqlstr,conn,3
rs.pagesize=10
请教高手为何会这样?谢谢!