SQL Data Source Settings

In this dialog you specify the settings of the connection to a data source used by ClearBox Server.

Data Source ID. This is an arbitrary name given to the data source at its creation and uniquely identifying it. No two data sources may have equal IDs.

Data source type. Select one of the following supported data connection types.

• MS Access (Microsoft Access database).
• MS SQL Server.
• ODBC data source (any database/server with ODBC driver).
• OLE DB data source (any database/server with OLE DB provider).

Depending on the data source type, the following settings are available:

Database path. The location of MS Access database file. It may be a fully-qualified path (e.g. 'c:\DB\mydb.mdb') or may start with the dot and slash (.\) - in this case it's opened from the \AAA\ folder (e.g. .\mydb.mdb).

User name. Is optional, and lets to specify the user login granted to access the data source.

Password. Is optional, and specifies the password of a database user.

SQL server. Used for MS SQL Server connections and specifies the IP address or machine name of the SQL server.

Database. Used for MS SQL Server connections and specifies the database to which connection is established

Use Windows authentication. If this option is selected, SQL server checks ClearBox Server authenticity by its Windows account (i.e. account under which ClearBox service runs), not by user name and password.

System DSN. Selects configured system DSN (Data Source Name) for an ODBC data source.

Connection string. Used to specify a connection string for an OLE DB connection. You will use 'Build' button to build the connection string rather than typing it from the scratch. Note, that a password is never stored in the string, and it's inputted in the Password box separately as it's stored encrypted.

Auto reconnect interval. Specifies the time interval (in minutes) when ClearBox should automatically reopen a connection with the data source. No reconnection occurs when this value is 0.

Test connection interval. Specifies the time interval (in minutes) when ClearBox should test a connection with the data source. It may be useful when the data source represents a connection to a remote database server, and network errors may occur. No connection testing occurs when this value is 0.

Automatically reconnect on errors. Turning this option on, you make ClearBox establish a new connection to the data source each time it fails.

Delayed connection. By default ClearBox Server opens connections with all configured data sources at startup. If this option is selected, then the connection is established just when it is really required for the first time.

Test Connection. Click this button before saving the data source settings to make a connection to the data source and verify that it is properly configured.

Apply Changes. Click to save the new data source settings or their changes.