Results 1 to 2 of 2

Thread: Adodb

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Sep 2002
    Posts
    120

    Adodb

    Hi,

    how can you tell how many records a ADODB connection has returned you can not use recordcount as you need to go through the list a least once for this to work. With other connections i use nomatch!

    Thanks

    Joolz

  2. #2
    Addicted Member PsudoLogical's Avatar
    Join Date
    Dec 2000
    Location
    Upstate N.Y.
    Posts
    144
    This is the resolution suggested by Microsoft for this issue that is a know situation with ADO:

    [q]Use either adOpenKeyset or adOpenStatic as the CursorType for server side cursors or use a client side cursor. Client side cursors use only adOpenStatic for CursorTypes regardless of which CursorType you select. [/q]


    The entire KB article is available via this link:

    KB 194973

Posting Permissions

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



Click Here to Expand Forum to Full Width