White Papers: Installing and Configuring PSQL/Zen Environments

By: Bill Bach

This page contains white papers created by Goldstar Software Inc. that discuss installing and configuring your Pervasive environment.

These documents are in Adobe Acrobat PDF format. Can't open them? Get the Acrobat Reader.

Downloading Actian Zen/PSQL Products

These documents cover everything you need to know on downloading the database products.

• Downloading Actian Zen v15 (Updated August 2021)
• Downloading Actian Zen v14 (Updated December 2020)
• Downloading Actian Zen/PSQL v13 (Updated April 2019)
• Downloading Actian PSQL v12 (Updated November 2018)
• Downloading Pervasive PSQL v11 (Updated November 2018)
• Updating Pervasive PSQL v10 to PSQLv10.30 or Newer (Updated January 2013)

Entering an Actian Zen/PSQL License

These documents cover everything you need to know about installing your database product license.

• Entering a Zen v15 License (Updated August 2021)
• Entering a Zen v14 License (Updated December 2019)
• Entering a PSQL v12 or v13 License (Updated December 2018)
• Entering a Pervasive PSQL v11 License (Updated December 2018)
• Entering a Pervasive PSQL v10 License (Updated December 2018)
• Entering a Pervasive PSQL V8/v9 License (Updated December 2018)

Setting Up ODBC Data Sources

These documents cover setting up an ODBC DSN on your server and client workstations.

• Creating an ODBC Data Source for Zen v15 (or v14) (Released June 2022)
• Creating an ODBC Data Source for PSQL v9, v10, v11, v12, v13, or Zen v14 (Updated June 2022)
• Creating an ODBC Data Source for PSQLv8 and Earlier (Updated December 2006)

Configuring the Zen/PSQL Database Environment

The rest of the documents cover other setup and configuration issues.

Checking your Zen/PSQL Installation for Proper Operation
If you are wondering if you have successfully installed the Zen/PSQL engine, here's how you can check the basic operations to make sure it is working. (Updated February 2021)

Virtualizing Your Zen/PSQL Database Servers
Virtualization is the latest hot topic in the IT industry. Read this paper to help determine if this solution will work for your Zen/PSQL database server! (Updated December 2018)

Tech Tip: Is My Zen/PSQL Database Cache Big Enough for My Data?
This white paper was released as a Tech Tip and helps you analyze your server to determine if your database cache is large enough for your data, or if you may need to adjust some settings. (Released February 2010) You can also read the Japanese version, translated by AgTech Pervasive Division.

Setting a Permanent Gateway
When using a Zen/PSQL Workgroup Engine, you may need to lock down the gateway to a single computer. Here's why & how.... (Updated December 2018)

Forcing the Requester Version Information
This article explains how to force the Zen/PSQL Client to return an older Version Number, so that older applications can work with the newer database engines. (Updated January 2015)

Making the Most of the Client Cache Engine
Are you running a terminal server with lots of users? Or do you run a lot of Btrieve reports which access lots of data? You may be able to get huge performance gains by properly configuring the Client Cache Engine in your environment! Check out this paper for more information on this feature.

Installing the Zen Client and ODBC DSN onto a Linux Computer
This paper goes step by step through the downlaod and install of the Zen v15 Client onto a Linux computer, including setting up and testing an ODBC DSN.

Installing the Zen v15 Engine onto a Raspberry Pi
This paper goes step by step through the downlaod and install of the Zen v15 Community Edition engine onto a Raspberry Pi computer, including configuration and monitoring from the local or a remote system.