When setting up access to an external DBMS for storage and processing of data, use the parameters described in the table below (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". For more information on transaction isolation refer to the documentation on the corresponding DBMS. |
|
To exclude encoding problems, you must disable the following parameters of the ODBC driver: •Use regional settings when outputting currency, numbers, dates and times—may cause errors during numerical parameter formatting. •Perform translation for character data—may cause incorrect characters to be displayed in Dr.Web Security Control Center for parameters that came from the DB. This parameter makes character display dependent on the language parameter for programs which do not use Unicode.
When creating a new database in the Microsoft SQL DBMS, you must specify the case-sensitive (has the _CS suffix) and accent-sensitive (has the _AS suffix) collation.
The following characters are undesirable: space, "{", ";" and "}", for more details see https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqldriverconnect-function?redirectedfrom=MSDN&view=sql-server-ver15. |
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 a Unix-like OS can be found at https://www.unixodbc.org/ in the Manuals section. |
ODBC Driver Setup for Windows OS
To configure ODBC driver parameters
1.On the Windows OS Control Panel, select Administrative tools; then double-click Data Sources (ODBC) in the pop-up window. The ODBC Data Source Administrator window will open. Go to the System DSN tab.
2.Click Add. A window for selecting a driver will open.
3.Select the corresponding ODBC driver for this DB on the list and click Finish. The first window for setting up access to the DB server will open.
|
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 (SQL Server Native Client), except for databases supplied by Microsoft without an ODBC driver. If you use MySQL, install and use the actual version of the ODBC driver from from the Microsoft website. |
4.Specify access parameters to the data source, the same as the 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 the IP address or name of the DB server. Click Next.
5.Select the With SQL Server authentication option and specify the 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. The Dr.Web Server database name must be specified, not the Default value.
Make sure that the following flags are set: Use ANSI quoted identifiers and Use ANSI nulls, paddings and warnings. Click Next.
|
If the 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 wil open.
8.To test the specified settings, click Test Data Source. After the notification of a successful test, click OK.