Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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("ADODB.Recordset")
  rs.open strsql, db, 3, 1
  set openrs=rs
end function
0
jdfulton
Asked:
jdfulton
  • 2
1 Solution
 
NopiusCommented:
try to open with another parameters:
rs.Open srtsql, db, adOpenKeyset, adLockOptimistic

or (the same):
rs.Open srtsql, db, 1,  3



0
 
jdfultonAuthor Commented:
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.
0
 
NopiusCommented:
Do you mean 'recordcounts always -1 when you use 1, 3'?
-1 is a normal valiue for recordcount for dynamic cursor type. Look here: http://www.w3schools.com/ado/prop_rs_recordcount.asp

0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now