Error: Pervasive Database is already in use

Error: Pervasive Database is already in use

Error:
Pervasive Database is already in use.

Solution:
If the FOS Database is not listed in the Pervasive Control Center, however the user receives an error that the database already exists when trying to create the database open the registry editor.
Locate the:
  1. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI.
  2. Locate the FOSData key and delete it.

  1. Then open the ODBC Data Sources key and delete the FOSData from inside of it.

The FOS Database will now be able to be re created in the Pervasive Control Center. Ensure the Create dictionary files (if they do not exist) and Relational integrity enforces boxes are unchecked and the Create 32-bit Engine DSN check box is checked.




    • Related Articles

    • FOS Database Encryption

      Prior to the FOS Database being encrypted all users must be logged out of FOS. This also applies to the Interface Manager and any display accounts as well. To confirm all users have been logged out open Pervasive software on the server and use the ...

    • Updating Pervasive

      All users will need to be logged out of FOS for Pervasive to be updated. Also, if users are accessing FOS using a shortcut on their computer once the version of Pervasive has been updated on the server the local machines will also need to update to ...

    • Error: set ok action: new data already enabled

      Error: FOS System Error - Report to CTA set ok action new data already enabled Solution: Have all users log out of FOS and restart the pervasive services on the FOS Server.

    • Repairing a Pervasive PSQL Key

      Before PSQL v11 SP3 a key in a Failed Validation or Disabled state meant a call to support. With Pervasive PSQL v11 SP3, Engineering has added a do it yourself Repair feature to the Pervasive License Administrator. It's simple to use - if your key is ...

    • Extracting Data from FOS Pervasive Tables

      Installing Pervasive & Initial Information *If Pervasive is already installed on the machine, please skip to the next section (Extracting Data from the Pervasive Database)* Before beginning the extraction, you will need to download and install ...