Database Connect Parameters

ConnectionName

Here, you can edit the connection name, if required.

Database Type

Here, you can select the database type: MySql, Oracle, Ms-SQL, Sybase, DB/2.

IP Settings

Destination IP Address

When establishing an active connection, you must enter the destination IP address. For passive connections, we recommend to enter the wildcard address (0.0.0.0).

Port

When establishing a connection, the default port for the corresponding database will be suggested. You can change it, if required.

Life Data Acks

Life data ACKs are frames that enable heartbeat monitoring. They are sent to keep up a database connection, even if no frames with payload are being exchanged. It is recommended to enable this function. If a WAN connection is used, you can disable this function for cost reasons. Otherwise, the TCP/IP connection will be kept up permanently.

Username

Here, you can enter the user name with which the device logs on to the database. Not all systems require a user name. To get the correct login data for the database, please ask the system administrator.

Password

Enter the password assigned to the user. Not all systems require a password. To get the correct login data for the database, please ask the system administrator.

Database

Here, you can enter the database name. For some database types, this is the database schema (MySql), others use this information as the starting point, still others only have one fixed database. Depending on the permissions allocated, database requests reset this database name.

Special Settings

This button gives access to special parameter settings for the selected database. Usually, these parameters are not required. If problems are encountered, you can compare these parameters with the database requirements.

Supported Database Versions and Char Sets for Oracle

Oracle Databases are connected using the Instand Client Light Version 10.2.0.5.0. It can connect to databases having one of the following database character sets. An error is returned if a character set other than those in the list is used as the client or database character set.

Oracle Database compatibility follows the support scheme of the Instant Client Library. Supported database versions:

deprecated but still supported: