Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Unanswered: w3btrv7.dll Timing Issue

    We are running Pervasive 8.7 using Microfocus Cobol and also accessing through VB .net and during one of our Cobol application if the user exits a sales order (which then the application issues the unlock command) and then immediately tries to go back into the same sale, they are receiving a message stating the sale is locked by their own user id. The unlock is issued using btrieve and by calling w3btrv7.dll. After the call is made the btrieve status is checked to see if it was successful. What we are wondering is if there are network issues or "slows" on the system, does w3btrv7.dll retry to access the file or will it "queue" and wait until it can get access, thus not returning an invalid status but also not unlocking the file until it has access? Does anyone know how this dll works and what controls there are on it?
    Thanks.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    If the BTRV call to unlock the record comes back with a status 0, then the record is unlocked.

    What actual Btrieve error code is being returned by the Cobol program when it says it's locked?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Feb 2007
    Posts
    3

    w3btrv7.dll Timing Issue

    It would appear that it is returning with a zero but the problem is that the application was written to set the status to zero PRIOR to the call so we don't know if the program is moving on without Pervasive really returning a value. The thought is that the call is being made and because of slowness in the system (the application is connecting to a terminal server not directly to the database server) Pervasive is "queing" up the request and the program doesn't truly wait for Pervasive to return a value. Do you know if this is possible? Would Pervasive truly return control to the calling program without receiving a status?
    Thanks.

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Do you know if this is possible? Would Pervasive truly return control to the calling program without receiving a status?
    No. Pervasive will not return control without receiving a status.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Feb 2007
    Posts
    3
    Thank you - that is what I needed to know!

Posting Permissions

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