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