OLTP DB
This tab contains parameters for the OLTP database connection. The OLTP database connection is used for registration of operational data such as material transactions, data acquisition etc.
Preferred JDBC driver
This is the JDBC driver to use for communication with the SQL server database. The jTDS JDBC Driver is reccommended for use with SQL server 2005
Computer
This is the name of the computer that hosts the SQL server database, or the name of the SQL server. If the SQL server is a named instance, this is indicated by a \ that separates the computer name and the instance name, e.g. localhost\sqlinstance.
 | Note! The jTDS JDBC Driver does not support the instance name notation. With the jTDS JDBC driver the instance is indicated by the Port. |
Port
This is the TCP/IP port to use for communication with the SQL server.
Database name
This is the name of the database.
Login name
This is the SQL server authentication login name. The best practice is to define a dedicated tracker login on the SQL Server. For security reasons it is not recommended to use the sa user.
Password
This is the SQL server authentication password.
Query timeout
Sets the number of seconds the jdbc driver will wait for a Statement object to execute to the given number of seconds. If the limit is exceeded, an SQLException is thrown and the actual transaction or query is terminated. Use with care! If a non zero value is supplied this must be greater than the maximum time that the server will take to answer any query.
Socket timeout
The amount of time to wait (in seconds) for network activity before timing out. Use with care! If a non zero value is supplied this must be greater than the maximum time that the server will take to answer any query. Once the timeout value is exceeded the network connection will be closed. Note: This property is only effective when using the jTDS JDBC driver.
Connection status
This is a read-only parameter showing the status of the database connection.
Database version
This is a read-only parameter showing the version of the connected Apis Click&Trace database.