Recordset Bookmark Problem

ADODB.Recordset error '800a0cb3'

Page 1 of 1

0 Replies - 2696 Views - Last Post: 31 May 2002 - 07:59 AM Rate Topic: -----

#1 Fygar  Icon User is offline

  • I liek milk!!1
  • member icon

Reputation: 3
  • View blog
  • Posts: 4,358
  • Joined: 28-March 02

Recordset Bookmark Problem

Posted 31 May 2002 - 07:59 AM

Ok, ladies and gents, Here's the deal. I am trying to use a bookmark in a recordset and it gives me the following:

Quote

ADODB.Recordset error '800a0cb3'

Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.

/grain/script/source.asp, line 94


And here is the code I am using to open it:

Quote

Connection() 'Fills connection crap.
RsStr = "SELECT * FROM "
RsStr = RsStr & "GP9TktSpColSrt Tscs "
RsStr = RsStr & "ORDER BY ColOrder ASC"
Rs.CursorType = adOpenStatic
'Rs.CursorLocation = adUseClient
Rs.Open RsStr, Conn,,, adCmdText

And it wigs out when it reches the bookmark write... So, I don't know what to do really.. I have tried many different locks and cursor types and such, but none worked... Could there be a database side to this that I am over looking? Thanks.

[edit] My spelling is as good as my code....

(Edited by Fygar at 11:19 am on May 31, 2002)


Is This A Good Question/Topic? 0
  • +

Page 1 of 1