Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Unanswered: Dropping connections

    Hey everyone.

    This just started happening about 2 days ago, and is happening at 2 sites, with 2 different programs (one accounting, one police reports). Both use Pervasive 8.6 on their respective servers.

    Occasionally, ALL users will be disconnected with errors ( I don't have them handy, but something of the type "attempting to access file at F:\DATA\name.dat"). So I am wondering:

    Do I need to check my IPs on the server?? Does the *DB* have it's OWN place where it tracks what it thinks its IP is? Does each client have a DP config file that says "you DB is at IP, with this config [subnet] [def gateway]" etc ect.

    It is really puzzling. I am wondering if its a big deal if clients and servers have different default gateways, again, I'm at home, but this might be the case. If I run the DB tests (including the ones with sample data), they run fine, but we still drop everyone randomly (sometimes every 15 minutes, sometimes once every 4 hours).

    Thanks for ANY help at all.

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    Check the PVSW.LOG at both the client and the server. Post any errors/messages that are listed around the time of the drops.

    THe DB does maintain a list of clients and the network address for that client (it can be either TCP/IP or SPX). It maintains this list internally.

    If you can get the exact error (and ideally the Btrieve/PSQL error) code, that would help too.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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