Pervasive Community Site

Community Forum (formally DEVTALK) – Join the ever- growing Pervasive community in a lively, interactive e-nvironment where users can come together and discuss their choice of topics on Pervasive-based products.  Participants include Developers, Resellers, System Integrators, and End User and Pervasive team members.

Component Zone – Download the latest utilities and tools posted by third-party vendors.  The Zone is your quick stop for getting the latest tools our partners have to offer.

What's New

  • Help - Trouble viewing an old database

    Hi, I am new to Pervasive SQL, so am a bit stuck. Hopefully this is a simple question that lots of you can answer. I have to connect by ODBC to two old databases that run under old software that are set up in Pervasive SQL. I think they used to be in ver 8. Perhaps older. Currently we have version 9.5 installed, and I can see three demo/default databases...
    Posted to PSQL Vx (Forum) by PhillipFranklin on 07-30-2016
  • Help connecting to old databases

    Hi, I am new to Pervasive SQL, so am a bit stuck. Hopefully this is a simple question that lots of you can answer. I have to connect by ODBC to two old databases that run under old software that are set up in Pervasive SQL. I think they used to be in ver 8. Perhaps older. Currently we have version 9.5 installed, and I can see three demo/default databases...
    Posted to General (Forum) by PhillipFranklin on 07-30-2016
  • Re: Pastel Users on network not displaying in Monitor Utility

    If I had to guess, I would think that you are NOT on the computer running the database engine. In it possible that some OTHER computer has taken over the task of serving up database files. Check the database folder for the file ~PVSW~.LOC. If it exists, use a command line and enter this command: "TYPE ~PVSW~.LOC" to display the contents of...
    Posted to Performance (Forum) by BtrieveBill on 07-28-2016
  • Re: Pervasive SQL v11 SP3 - Data files not accessible via DFS Path

    I think the error gives you a clue. Check the REAL file location. If the Y: drive is pointing to \\erverproddr\data, and the application is trying to open Y:\DATA\APINFO.btr, then the complete file path will be \\erverproddr\data\DATA\APINFO.btr. Is there a DATA folder underneath the data folder? Or should the app be accessing Y:\APINFO.btr instead...
    Posted to General (Forum) by BtrieveBill on 07-28-2016
  • Re: Pervasive SQL v11 SP3 - Data files not accessible via DFS Path

    Hi Bill, Thank you very much for your reply. I totally now understand that DFS is not going to work with Pervasive database. Inorder to find the alternate solution, I have explored other options. One the option to setup DR server is to have a DNS name. This DNS will point to either Primary or DR server. I am testing this by creating a host file entry...
    Posted to General (Forum) by sduddu on 07-28-2016