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
- OLE DB data source (any database/server with OLE DB
Depending on the data source type, the following settings are
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
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
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
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.
© 2001-2007 XPerience Technologies. www.xperiencetech.com