jdfulton
asked on
ACCESS to MYSQL Error Current Recordset does not support bookmarks
I am getting the following error and I have found nothing that fixes the problem. I moved from ACCESS to MYSQL.
Here is the line it errors on. I don't think rs.recordcount works either. I have tried a DSNLess and DSN connection. Using db.open for db. It works fine in Access.
rs.absolutepage = currentpage
Here is my connection info.
function openrs(strsql)
set rs=server.createobject("AD ODB.Record set")
rs.open strsql, db, 3, 1
set openrs=rs
end function
Here is the line it errors on. I don't think rs.recordcount works either. I have tried a DSNLess and DSN connection. Using db.open for db. It works fine in Access.
rs.absolutepage = currentpage
Here is my connection info.
function openrs(strsql)
set rs=server.createobject("AD
rs.open strsql, db, 3, 1
set openrs=rs
end function
ASKER
If I try that I get the following error. Recordcounts always end up being -1 if I use 3, 1.
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
rs.Open srtsql, db, adOpenKeyset, adLockOptimistic
or (the same):
rs.Open srtsql, db, 1, 3