AGG Software
Ask a question  Top  Previous  Next

Database settings

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.

 

database settings

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.





Copyright © 1999-2016, AGG Software.
All rights reserved.