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
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 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). ...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 ...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: 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 ...