SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    May 2001
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    asp recordset and connection

    i've put some code up here for review in the past, but all i have now is a simple question....

    if i have a database which i know will be accessed and updated by more than one person at the same time, is it a bad thing to have more than one recordset? i have one connection, 3 recordsets.....i am using adLockPessimistic as well.....

    any thoughts?

    thanks!

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,264
    Mentioned
    115 Post(s)
    Tagged
    1 Thread(s)
    I don't know what AdLockPessimistic does, but overall you shouldn't have a problem. The biggest concern would be to make sure that multiple people can't try to update the same RECORD at the same time.....
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  3. #3
    SitePoint Member
    Join Date
    May 2001
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thanks

    yeah, my main concern is that the records and updates don't get messed up when there is more than one person accessing the dbase. thanks for the reply!

  4. #4
    Xbox why have you forsaken me? moospot's Avatar
    Join Date
    Feb 2001
    Location
    Clearwater, FL
    Posts
    3,615
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    adLockReadOnly Indicates that the records cannot be modified

    adLockPessimistic Indicates that a record should be locked immediately upon editing

    adLockOptimistic Indicates that a record should be locked only when the Recordset's update method is called

    adLockBatchOptimistic indicates that the records will be batch-updated

    Source: http://www5.ewebcity.com/ec1/intro/R..._tutorial.asp.

  5. #5
    SitePoint Member
    Join Date
    May 2001
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thanks

    thats what i thought


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
  •