Setting up GainSeeker on a MySQL database

MySQL will function as expected with these component versions. Other versions of the .NET connector and ODBC driver have sometimes produced unexpected results.

MySQL database server version 5.1.26
MySQL .NET connector version 5.0.8.1 or 6.4.6
MySQL ODBC driver version 3.51

Because the latest version of the MySQL database that worked consistently with GainSeeker is no longer supported, Hertzler Systems no longer recommends MySQL as one of the database options for new deployments of GainSeeker, and MySQL components are no longer included with GainSeeker installation media.

Existing MySQL deployments are still supported.

For a new GainSeeker deployment on a free database, Hertzler recommends Microsoft SQL Server Express.

Your database administrator (DBA) must perform the following steps on the MySQL database server:

Create a new GainSeeker database. Locate the SPC8_my.sql script provided in the \Scripts\MySQL\ folder in the GainSeeker installation package.

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.

Create a User for this GainSeeker database.

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

Create all necessary tables in the GainSeeker database.
- If you plan to use the typical GainSeeker table structures, use the default SPC8_my.sql script in the \Scripts\MySQL\ folder.
- If you plan to use Expanded data fields, edit the script and update the variables @DBPSD, @DBPD, and @DBUDL to the desired field lengths.
- If you plan to use Additional traceability columns, edit the script and add columns to the DDAT_AUX, VDAT_AUX, and VMON_AUX tables (see comments in the script file)..

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. Advanced options to "Return matching rows" and "Pad Char To Full Length" will be selected for you.
If you edited the script for expanded data fields or additional traceability columns, you must use the GainSeeker System Administration module to set the field lengths or additional traceability columns on the Initial Configuration:
1. Go to the settings for Tables and File Paths and click the Expand column length and/or the Additional Traceability Column button and set the appropriate values.