Why RS.AbsolutePage is not supported?

I'm using DSN-less Access database.
This error occurs when the following line is added to the code.

objPagingRS.AbsolutePage = iPageCurrent

Error:

ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

Pls advise why this application is not supported and any way to rectify it?
qiang8Asked:
Who is Participating?
 
daveamourConnect With a Mentor Commented:
It may be that you are using the wrong type of cursor for your recordset.  I beleive that certain cursor types do not support the AbSolutePage property.

For example the following line uses a Forward only cursor

rs.Open strSQL, objADO_ComInfo, adOpenForwardOnly, adLockPessimistic, adCmdText

There are other types of cursors available as follows

adOpenForwardOnly
adOpenKeyset
adOpenDynamic
adOpenStatic

Try changing the cursor to a different type.  For example to change to a Statit cursor you would use

rs.Open strSQL, objADO_ComInfo, adOpenStatic, adLockPessimistic, adCmdText

Note that these names are constants which are declared in ADOVBS.INC so if you do not have this file included in your asp page then refer to the cursors by number rather than name.  The numbers are as follows

adOpenForwardOnly..... 0
adOpenKeyset.......... 1
adOpenDynamic......... 2
adOpenStatic.......... 3

So again to open a recordset with a static cursor referring to it by number you would use this

rs.Open strSQL, objADO_ComInfo, 3, adLockPessimistic, adCmdText

Hope this helps

Dave


0
 
qiang8Author Commented:
Thanks a lot. It is due to improper use of cursor type.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.