B1. Setting Up the ODBC driver

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).

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—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.

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.

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.

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.

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.