Running a Script or Command in Pervasive PSQL

Note: Depending on the script, users may or may not need to be logged out of FOS.

1. Open the Pervasive Control Center on the FOS Server.

2. Select "Execute SQL Commands" and then select the FOS Database. Click "OK."

3. Type in the command / script.

4. Select "SQL" --> "Execute All SQL statements"

• Related Articles

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

• Error: 1053: The service did not respond to the start or control request in a timely fashion. When restarting Pervasive Services

  Error: Windows could not stop the Pervasive PSQL Relational Engine 1053: The service did not respond to the start or control request in a timely fashion. Solution: In Task Manager, on the Processes tab find DATABASE SERVICE MANAGER (32 bit) or ...

• Error 7132: The PSQL engine type for this key does not match the installed PSQL engine.

  Error: 7132: The PSQL engine type for this key does not match the installed PSQL engine. Solution: Is the correct version of Pervasive installed? Confirm the pervasive version the key belongs with (can be done with Amie or the Master Data Sheet). ...

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