Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    17

    Unanswered: Default cursor in SQL 2000

    Hello,

    I am writing an application which I would like to use a server cursor on. I have noticed that when I try to access a table that I have created using a server cursor with my app, I have problems getting the information. It says that the cursor doesn't support bookmarks. But, when I access the Employees table on the Northwind database with the same settings, everything is fine. Is there some sort of option I'm missing with my tables? Some default cursor or something? Is there a way to tell what cursors are defined with the Northwind DB? Any help would be great, thanks!

  2. #2
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Check if your table has a primary key
    --
    kukuk

  3. #3
    Join Date
    Apr 2003
    Posts
    17
    that was it, thank you very much!

    Originally posted by kukuk
    Check if your table has a primary key

  4. #4
    Join Date
    Apr 2003
    Posts
    17
    Would something similar also go for the dynamic cursor? I setup the primary keys which works great for Keyset type. But I get the old 'Dataset does not support bookmarks' when trying a dynamic cursor on the same dataset. I've tried both MSDASQL and SQLOLEDB providers, both gave errors.

    Originally posted by Thread77
    that was it, thank you very much!

Posting Permissions

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