SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot Imran-Saami's Avatar
    Join Date
    Sep 2004
    Location
    Pakistan-Dubai
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy CursorType-LockType Conflicts...

    Its a quite beginner level question which I gonna post here now... but I know you all are very tolerant...

    The problem is on the combination of ADO cursor type and LockType... I've matched almost all of these combinations, but every time.. i got the same error of conflict between cursor and lock types...

    I appreciate if anybody can look down on the code and can help me out...


    'Declare ADO Lock Types constants
    Const adLockUnspecified = -1
    Const adLockReadOnly = 0
    Const adLockPessimistic = 1
    Const adLockOptimistic = 2
    Const adLockBatchOptimistic = 3

    'ADO Cursor Type constants
    Const adOpenUnspecified = -1
    Const adOpenForwardOnly = 0
    Const adOpenKeyset = 1
    Const adOpenDynamic = 2
    Const adOpenStatic = 3

    RS.Open strSQL, sconnect, adOpenStatic , adLockReadOnly

    I'm recieving an error on the above line:
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.



    Thanks in advance...

  2. #2
    SitePoint Zealot Imran-Saami's Avatar
    Join Date
    Sep 2004
    Location
    Pakistan-Dubai
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Please dont reply to this post,,,
    I've found the problem..

    in fact Locktype and cursor were correct, but the #Include file which defines sConnect (DB querystring) was not included on the top...

    Believe me it wasted my whole day

    Sorry..


Bookmarks

Posting Permissions

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