Setting up GainSeeker on a Pervasive.SQL database

Your database administrator (DBA) must perform the following steps on the Pervasive.SQL database server:

1. Create a new GainSeeker database. Two variations of the example script for creating the database and tables, SPC8_Per.SQL, are provided in the \Scripts\Pervasive\ and \Scripts\Pervasive\Expanded\ folders in the GainSeeker installation package, but both use the same SQL statements to create the database.

You may choose either a case insensitive (recommended) or a case sensitive Collate option for the new database. When using the case sensitive option, all table names and field names will also be case sensitive.

2. Create a User for this GainSeeker database.

For the GainSeeker database, grant all privileges to this user.

3. Create all necessary tables in the GainSeeker database. A script for creating and populating the necessary tables, SPC8_Per.sql, is provided in the \Scripts\Pervasive\ folder in the GainSeeker installation package.

   • If you plan to use the typical GainSeeker table structures, use the SPC8_Per.SQL script in the \Scripts\Pervasive\ folder.

   • If you plan to use Expanded data fields, use the SPC8_Per.SQL script in the \Scripts\Pervasive\Expanded\ folder and update the variables DBPSD, DBPD, and DBUDL to the desired field lengths.

After setting up the database, you can install the GainSeeker client on each workstation.

• The first GainSeeker client installation will prompt you to enter the database server name, User name, Password, and GainSeeker Database.

• If you used the script for expanded data fields, you must use the GainSeeker System Administration module to set the field lengths for the Initial Configuration:

• 1. Go to the settings for Tables and File Paths and click the Expand button. This will display the Expand Column Lengths window with default column lengths.

  2. Set the three column lengths to match the three variables in the script you executed, then click OK.