<< Click to Display Table of Contents >>

Navigation:  Program use > Configuration > SQL data >

Connection parameters

The connection parameters described below configure the connection on the software level. You can set these parameters on the "Connection parameters" tab (fig. 2.10.1).

 

sqlsrc1

Fig. 2.10.1 Connection parameters

 

Using the "Stay connected" and "Idle timeout" options, you can specify the connection type. The "Stay connected" option makes the module connect to the database once needed and maintain the connection until the program is closed. The "Idle timeout" option makes the module disconnect if no data is exported for the number of seconds.

 

Server - the database type.

 

Depending on the selected database type, use the "Database" field to specify the following:

 

DB2, Informix and ODBC – specify DSN set in the "ODBC Administrator" or the complete description of the data source with the parameters supported by the selected server. You can see an example of this field for the Informix server below:

 

SERVICE=ids_srv;HOST=yourhost;PROTOCOL=OLSOCTCP;SERVER=ids_srv;DATABASE=sysmaster;UID=informix;PWD=informix.

 

Interbase – specify the path to the necessary database and the network protocol (see the examples below).

 

Value

Protocol

<server_name>:<filename>

TCP

\\<server_name>\<filename>

NetBEUI

<server_name>@<filename>

SPX

 

         

Oracle – specify the host name/service name.

MySQL, MS SQL Server or Sybase SQL Server – if you establish a connection with a remote server, specify its name and the database name separated with a colon. For example, remsrv:dbname points to the DBNAME database situated on the REMSRV sever. Specify (local) for a local database. For example, 192.168.1.1:server_name

 

Then specify username and password to access the database in the "Login" and "Password" fields respectively.

 

For MS SQL Server you may not specify the login and password. In this case, the program will use Windows Authentication.

 

For ODBC you may not specify the login and password. In this case, the program will use login and password from the ODBC alias settings.

 

Use the "Additional connection attributes" field to specify connection parameters unique for each server.

 

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 sent 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 authorization

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 that 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.


                 

After you set up your database connection, you can immediately test it by clicking the "Test connection" button. The program will try to connect to the database. The process can take rather long (up to three minutes) depending on the database type. A message will be displayed as the test result. If an error occurs, the message will contain the server response that will help you find out what has caused the error.