When setting access to DBMS for storage and processing of data, use the parameters described below for external DBMS.
ODBC parameters (only in the version for Windows OS)
Name |
Default value |
Description |
|---|---|---|
DSN |
Drwcs |
Data set name |
USER |
Drwcs |
User name |
PASS |
Drwcs |
Password |
TRANSACTION |
DEFAULT |
Read below |
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 the Dr.Web 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 Enterprise Server is installed. To do this
1.In Windows OS Control Panel, select Administrative tools; in the opened window 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.Enter access parameters to the data source (the same as in the settings of Enterprise Server). If the DB server is not installed on the same computer as Enterprise Server, in the Server field specify its IP address or name. Click Next. The next window will be opened.
5.Specify the necessary DB access settings in this window. Click Client configuration. A window for selecting and setting the network protocol will be opened.
6.In the Network libraries field select a network library for TCP/IP or Named Pipes (recommended). If the DB server is not installed on a local computer, specify its name or IP address in the Server alias and Server name fields. Click OK. This window will close and the previous window for setting the driver will be available again. Click Next. The next window will be opened.
7.Check that the Only when you disconnect option, the Use ANSI quoted identifiers and the Use ANSI nulls, paddings and warnings flags are set. Click Next. The last window for setting access will be opened.
|
If ODBC driver settings allow you to change the language of SQL server system messages, select English. |
8.Select the necessary parameters. When you are done, click Finish. A window with the summary of the specified parameters will be opened.
9.To test the specified settings, click Test Data Source. After you see a notification of a successful test, click OK.