User's Guide
What It Is
What's New
Key Features List
ClearBox Enterprise vs ClearBox
System Requirements
Purchasing Licenses
Getting Started
Quick Start
Understanding Server Components
Managing User Accounts
Configuring RADIUS Realms
Realm Settings
Realm Rules
Dynamic Realm Rules
Authentication Protocols Compatibility
Logging Authentication Packets
Logging Discarded Requests
Account Log Files
Realm Settings
Configuring SQL Queries
Private RADIUS Attributes
Regular Expressions Syntax
RADIUS Clients
RADIUS Client Settings
Dynamic Clients Settings
SQL Data Sources
SQL Data Source Settings
LDAP Servers
LDAP Server Settings
Remote RADIUS Servers
Remote RADIUS Server Settings
State Servers
State Server Settings
Meta Configuration
Meta Configuration
Meta Configuration Settings
Meta Base Schema
TLS Settings
Creating SSL Certificates
Creating Server Sertificate
Requesting Server Certificate
Creating Client Certificates
Revoking a Certificate or Renewing CRL
Exporting CA Certificate
Issuing a Certificate in Active Directory CA
Remote Configuration
Advanced ISP Billing Integration
DTH Billing Integration
Platypus Billing System Intergration
OnDO SIP Server Integration
How Do I...
Wi-Fi Security
Wireless Authentication
Wi-Fi and RADIUS
Supported EAP Authentication Types
Security Considerations
10 Tips for Wireless Network Security
Administering the Server
Debug Logs
Using Client Tool
List of Server Errors
Maintaining RADIUS Dictionary
Basic Concepts
Wireless Authentication
Authentication Protocols
RADIUS Attributes
Example of RADIUS Packet Transactions
List of Standard RADIUS Attributes
Technical Support
Purchasing Licenses

ClearBox Enterprise Server 2.0 Online Manual
Prev Page Next Page
ClearBox Enterprise Serverâ„¢ 2.0. User's Guide

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.

© 2001-2007 XPerience Technologies.
Converted from CHM to HTML with chm2web Pro 2.7 (unicode)