Skip to main content
Version: 5.6

Shared Connection Settings

The following settings are structured identically across the OPC Router’s relational database plug-ins. The plug-in-specific pages refer to this section.

Advanced Connection Parameters​

PropertyDescription
Command Timeout (s)Maximum time in seconds that the OPC Router waits for an SQL command to execute. For slow or very large queries, it may be necessary to increase this value.
Connection Timeout (s)Maximum time, in seconds, allowed to establish a connection to the database.
Concurrent ConnectionsNumber of database connections that the OPC Router is allowed to open simultaneously. Higher values can speed up processing, but they also increase the load on the database server and the network.
Polling IntervalThe time interval at which the OPC Router cyclically checks the database for changes.
note

Not every plug-in offers all parameters; depending on the database system, some may be omitted.

warning

If you increase the "Command Time-out" value, you should also adjust the timeout for the affected OPC router transfers. Otherwise, the timeouts may overlap and cause errors.

Bracket Behavior​

The parentheses behavior determines when SQL identifiers, such as table or column names, are enclosed in square brackets.

  • Automatic: The OPC Router decides on a case-by-case basis whether an identifier, such as a table or column name, must be enclosed in square brackets. This decision is based on the specifications of the database system.
  • Never enclose SQL identifiers in square brackets: The OPC Router does not add square brackets. This is particularly useful if your identifiers have a simple structure and do not contain special characters, spaces, or reserved words.
  • **Always enclose SQL identifiers in square brackets: The OPC Router encloses all identifiers in square brackets. This can be useful if object or column names may contain special characters, spaces, or reserved words.