Setting up GainSeeker on a MySQL database

Note: MySQL will function as expected with these component versions (shipped with GainSeeker). 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

 

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

  1. Create a new GainSeeker database. Two variations of the example script for creating the database and tables, SPC8_my.sql, are provided in the \Scripts\MySQL\ and \Scripts\MySQL\Expanded\ folders on the GainSeeker installation CD, 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.

  1. Create a User for this GainSeeker database.

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

  1. Create all necessary tables in the GainSeeker database.

 

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