Paging with SQLOLEDB

Results 1 to 2 of 2

Thread: Paging with SQLOLEDB

  1. #1
    Nat Thompson Guest

    Default Paging with SQLOLEDB

    Whenever I try to load a page with the .absolutepage property set, I receive the following error.<BR><BR>ADODB.Recordset error &#039 800a0cb3&#039 <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>/corp/titledisplay.asp, line 21 <BR><BR>Any ideas?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Paging with SQLOLEDB

    Only certain cursor types support AbsolutePage. If you want to page and you are using SQL server, I strongly recommend you use the stored procedure approach. There is an article about this at:<BR><BR><BR>Also, you can learn more about database cursors from the following article:<BR><BR>Recordset Cursors - Choosing the Right Cursor for the Job<BR><BR><BR>Happy Programming!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts