 |
 |
|
The program can work with practically any database that has an ODBC driver. By default, the program is configured for the Microsoft Access database that comes with the program. You can change the connection type during the installation of the program or using the dialog box in the preferences of the program (fig.21). 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.21 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:
| • | Microsoft Access – the path to the database and its file name. |
| • | DB2, Informix и ODBC – DSN configured in the “ODBC administrator” or the complete description of the data source with parameters supported by the selected server. Below you can see a sample record for the Informix server: |
SERVICE=ids_srv;HOST=yourhost;PROTOCOL=OLSOCTCP;SERVER=ids_srv;DATABASE=sysmaster;UID=informix;PWD=informix.
| • | Interbase – the path to the necessary database and the network protocol (see the table below). |
Value |
Protocol |
<server_name>:<filename> |
TCP |
\\<server_name>\<filename> |
NetBEUI |
<server_name>@<filename> |
SPX |
| • | Oracle – host name/service name. |
| • | MySQL, MS SQL Server or Sybase SQL Server – 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 local 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 and Sybase |
HOST NAME |
The name of the workstation that will be send to the server |
Only for MSSQL and Sybase |
COMMAND TIMEOUT |
The number of seconds to wait until any operation is finished |
Only for MSSQL, ODBC, SQLBase, Sybase |
COMPRESSED PROTOCOL |
Use compression while exchanging data between the client and the server. By default, the value is TRUE |
Only for MySQL
|
ENABLE BCD |
Change the NUMERIC data type into the BCD data type before sending data to the server |
Only for Oracle, Interbase |
ENABLE INTEGERS |
Change the NUMERIC data type into the INTEGER data type before sending data to the server |
Only for Oracle, Interbase |
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 |
ENCRYPTION |
Use encrypted passwords when accessing the database. By default, this value is FALSE |
Only for Sybase |
FIELD REQUIRED |
Display an error message if any field has the NULL value when a query is executed |
|
FORCE OCI7 |
Use OCI7 (SQL*Net 2.x - Oracle7 interface) to access the Oracle server |
Only for Oracle |
LOCAL CHARSET |
Set the encoding character set |
Only for Interbase |
LOGIN TIMEOUT |
The number of seconds to wait for user authorisation |
Only for DB2, Informix, ODBC, MSSQL, MySQL, Sybase |
MAX CURSORS |
The maximum number of simultaneously opened cursors |
Only for MSSQL and Sybase |
MAXCHARPARAMLEN |
The maximum line length. By default, it is 255 |
|
MAXFIELDNAMELEN |
The maximum length of a field name. By default, it is 50 |
Only for Oracle |
MAX STRING SIZE |
Limit the size of strings to this value. Longer strings will be considered a blob |
Only for Firebird, Interbase, ODBC |
NEW PASSWORD |
Use this value when the server returns the 'Password expired' message |
Only for Oracle8 |
QUOTED IDENTIFIER |
Use identifiers in quotes |
Only for MSSQL and Sybase |
PREFETCH ROWS |
The number of rows to be prefetched in order to minimize network traffic (Oracle8: this option does not work if SELECT contains fields of the LONG type) |
Only for DB2, Informix, ODBC, Oracle8 |
ROLE NAME |
Specifies the role the server should assign to the client when it is connected |
Only for Interbase and Oracle (SYSDBA/SYSOPER roles) |
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 and Sybase |
SQL DIALECT |
Installs SQL Dialect (1,2,3) for the client |
Only for Interbase |
TDS PACKET SIZE |
Specifies the size for a TDS packet. If the server does not support this size, a "Login failed" error will occur in the process of connecting |
Only for Sybase |
TRANSACTION LOGGING |
If it is FALSE, transaction logging will be disabled, so rollback will be unavailable |
Only for SQLBase |
RTRIM CHAR OUTPUT |
Delete spaces on the right for fields of the CHAR type. By default, it is TRUE |
Only for DB2, Informix, Interbase, Oracle, ODBC and Sybase |
XA CONNECTION |
Indicates that it is necessary to connect to the TM service with the name specified in the "Database name" field. By default, it is FALSE |
Only for Oracle8i |
XXX API LIBRARY |
Specifies the interface library type to use for connecting, where XXX stands for server type. For example, Oracle, SQLServer, Interbase, etc. |
 |