Database settings

<< Click to Display Table of Contents >>

Navigation:  Program use > Administration and reports >

Database settings

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.

 

database-settings

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