The program can work with practically any database that has an ODBC driver. By default, the program is configured for the PostgreSQL database that comes with the program. You can change the connection type during the program's installation or using the dialog box in the program's preferences (fig. 26). Select "Edit - Preferences..." and switch to the "Database" tab to configure the connection.
Note: These settings change the connection type only for the administration part. Data export to the logger is configured separately.
Fig. 26 Database connection settings
Connection parameters are specified in the "Identification" group.
Depending on the database type selected in the "Database type" list, the following is specified in the "Database name" field:
If you configure a connection to the remote server, specify the server name and the database name separated with a colon. For example, remsrv:dbname points to the DBNAME database located on the REMSRV server.
You should specify "localhost" instead of "remsrv" for a local database.
Then specify the username and password for access to the database in the "Login" and "Password" fields, respectively.
Specify the connection parameters specific for each server in the "Additional connection parameters" input field.
After you configure the database connection, you can test it immediately by clicking the "Test connection" button. The program will try to connect to the database. It may take quite a while (up to three minutes), depending on the database type. The test result will be shown as a message. In case of an error, the message will contain the server response that will help you determine what caused it.
Additional connection parameters
Value |
Description |
Note |
AUTOCOMMIT |
Use autocommit |
|
APPLICATION NAME |
The name of the application that will be sent to the server |
Only for MSSQL |
HOST NAME |
The name of the workstation that will be sent to the server |
Only for MSSQL |
ENABLE MONEY |
Change the NUMERIC data type into the CURRENCY data type with the precision (1-4) before sending data to the server |
Only for MySQL |
FIELD REQUIRED |
Display an error message if any field has the NULL value when a query is executed |
|
LOGIN TIMEOUT |
The number of seconds to wait for user authorization |
MSSQL, MySQL |
MAX CURSORS |
The maximum number of simultaneously opened cursors |
Only for MSSQL |
QUOTED IDENTIFIER |
Use identifiers in quotes |
Only for MSSQL |
SERVER PORT |
Specifies the server port for connecting via TCP/IP |
Only for MySQL, PostgreSQL |
SINGLE CONNECTION |
Specified whether to use a single process/connection. By default, it is FALSE |
Only for MSSQL |