Results 1 to 7 of 7

Thread: Sole-Access ???

  1. #1
    Join Date
    Jul 2005
    Location
    Cape Town, South Africa
    Posts
    5

    Unanswered: Sole-Access ???

    Hi.

    I am currently experiencing a problem where a workstation is having problems connecting to some shared Btrieve data files.

    When no other workstation is working on the data files, the problem workstation opens the data perfectly, but it does not allow any other workstation to access the data after is has opened it.

    When another workstation has opened the data the problem workstation cannot access the data. It's almost as if the workstation requires sole-access. Apparently the problem started to occur after a power outage.

    Other workstations do not share this problem. All workstations use Pervasive V8.

    Any idea how to fix this ?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    A few questions:
    - Is the PSQL v8 a workgroup or server install?
    - If it's a Workgroup, where are the data files? Are they on a server or local?
    - WHat error do you get?
    - Can you access the files using the Pervasive tools (Pervasive Control Center, Function Executor, etc)?
    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
    Jul 2005
    Location
    Cape Town, South Africa
    Posts
    5
    Thanks for the reply.

    -All the workstations use the workgroup engine.
    -The datafiles are located on the a server.
    -I don't have the exact error message at hand but it was something about a
    file not found. I'll try to get the exact message again.
    -Once another workstation has opened the data, I could not open the data on the particular workstation through the Control Centre or Btrieve utilities.

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    One more question, was the error from the PCC or Function Executor the same as from within Access?
    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
    Jul 2005
    Location
    Cape Town, South Africa
    Posts
    5
    I cannot recall what the Btrieve utility returned, but I don't think it was the same.

  6. #6
    Join Date
    Jul 2005
    Location
    Cape Town, South Africa
    Posts
    5

    Btrieve Status 116

    I did a bit of homework on my previously reported error.

    The Control Centre error message simply stated that the microkernel cannot find 'the specified file'.

    But when I used the utilities to connect to the data I received the more informative response of 'Btrieve Status 116 - Another gateway engine owns the locator file."

    After a bit of searching I tried connecting to the 'server' and the gateway owner with Smart Scout. I could actually connect to the gateway owner by means of NetBIOS, but I couldn't connect to the server (TCP/IP connect error 10060).

    I will try to fix the gateway on the 'server' tomorrow and see if that helps but any other suggestions would be welcome.

  7. #7
    Join Date
    Jul 2005
    Location
    Cape Town, South Africa
    Posts
    5

    Problem Resolved

    The problem has been resolved. It was caused by the incorrect TCP/IP settings. Apparently the DNS setting was incorrect which prevented the problem computer from communicating with the other computer via TCP/IP. Probably similar to the situation often cited as a cause for status 116 where computers seperated by router cause the same error, but I'm just guessing.

Posting Permissions

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