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

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.

warning

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.

info

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.

warning

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.

info

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.