OLE DB

Options for OLE DB Providers

warning

Attention: OLE DB is not supported in Docker.

OLE DB connections need a connection string. The OLE DB provider needed has to be installed and must be active.

Name	Name of the configuration
Connection string	Select a connection string from the drop-down menu.
Command time-out	Time (seconds) that the Router waits for an SQL command to terminate. Increase if your projects involve commands of long duration (e. g. stored procedures). Note that you also need to increase the value for the individual connections that trigger long queries.
Command time-out	Time (seconds) that the router waits for a command to complete. For long queries, it may be necessary to increase the value. Note that you also need to increase the value for the individual connections that initiate long queries.
Connection time-out	Time (seconds) that the Router may need to establish connection.
Parallel connections	Number of connections that the Router may establish parallely. The more connections the faster the Router the slower probably the database. Ask your database administrator how many connections the Router may establish. This depends on your project’s scale, of course.
Polling interval	Distance at which the database is queried.