When setting access to DBMS for storage and processing of data, use the parameters described in the table below for external DBMS (specific values are given for example).
Parameters for ODBC connection
Name |
Value |
Description |
|---|---|---|
DSN |
drwcs |
Data set name |
USER |
drwcs |
User name |
PASS |
fUqRbrmlvI |
Password |
TRANSACTION |
DEFAULT |
Possible values of the TRANSACTION parameter: •SERIALIZABLE •READ_UNCOMMITTED •READ_COMMITTED •REPEATABLE_READ •DEFAULT The DEFAULT value means "use default of the SQL server". More information on transactions isolation see in documentation on corresponding DBMS. |
|
To exclude encoding problems, you must disable the following parameters of ODBC-driver: •Use regional settings when outputting currency, numbers, dates and times—may cause errors during numerical parameters formatting. •Perform translation for character data—may cause illegal characters displaying in Dr.Web Security Control Center for parameters, which are came from the DB. This parameter sets symbols displaying dependence on the language parameter for programs, which do not use the Unicode.
When creating a new database in the Microsoft SQL DBMS, you must specify the collation that is case sensitive (has the _CS suffix) and accent-sensitive (has the _AS suffix). |
The database is initially created on the SQL server with the above mentioned parameters.
It is also necessary to set the ODBC driver parameters on the computer where Dr.Web Server is installed.
|
Information on ODBC driver setup under UNIX sytem-based OS you can find at http://www.unixodbc.org/ in the Manuals section. |
ODBC Driver Setup for Windows OS
To configure ODBC driver parameters
1.In Windows OS Control Panel, select Administrative tools; in the opened window double-click Data Sources (ODBC). The ODBC Data Source Administrator window will be opened. Go to the System DSN tab.
2.Click Add. A window for selecting a driver will be opened.
3.Select the item of the corresponding ODBC-driver for this DB in the list and click Finish. The first window for setting access to the DB server will be opened.
|
If an external DBMS is used, it is necessary to install the latest version of the ODBC driver delivered with this DBMS. It is strongly recommended not to use the ODBC driver supplied with Windows OS. Except databases, supplied by Microsoft without ODBC-driver. |
4.Specify access parameters to the data source, the same as parameters in the settings of Dr.Web Server. If the DB server is not installed on the same computer as Dr.Web Server, in the Server field, specify IP address or name of the DB server. Click Next.
5.Select the With SQL Server authentication option and specify necessary user credentials to access the DB. Click Next.
6.In the Change the default database to drop-down list, select the database which is used by Dr.Web Server. At this, the Server database name must be obligatory specified, but not the Default value.
Make sure that the following flags are set: Use ANSI quoted identifiers and the Use ANSI nulls, paddings and warnings. Click Next.
|
If ODBC driver settings allow you to change the language of SQL server system messages, select English. |
7.When you complete the configuration, click Finish. A window with the summary of the specified parameters will be opened.
8.To test the specified settings, click Test Data Source. After notification of a successful test, click OK.