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.

    • 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 ...

    • Error: Pervasive.Data.SqlClient.Lna.k: [LNA] [PSQL] [SQL Engine] [Data Record manager] Cannot locate the named database you specified (Btrieve Error 2301)

      Error: Pervasive.Data.SqlClient.Lna.k: [LNA] [PSQL] [SQL Engine] [Data Record manager] Cannot locate the named database you specified (Btrieve Error 2301) This error will appear when running the FOS Mobile Web test. Solution: 1. Verify that a ...