User manual

The example below illustrates one of many possible configuration possibilities for
the ADO string. For more detailed information on this and other options and
configurations of the MS SQL ADO string please refer to the applicable
documentation from Microsoft.
Sample connection string:
Provider=SQLOLEDB;User
ID=[ADOUser];Password=[ADOPwd];Trusted_Connection=No;Initial
Catalog=[DBCatalog];Data Source=LOCALHOST\SQLEXPRESS;
a. Provider=SQLOLEDB; mandatory parameter needed to specify the provider.
Enter the value manually (no Avira AntiVir Exchange variable available).
b. User ID=[ADOUser];Password=[ADOPwd]; mandatory parameters; enter
the parameters ’User ID=’ and ’Password=’ manually in the string and
set the Avira AntiVir Exchange variables Database user and Password. The
inserted variables [ADOUser] and [ADOPwd] will be replaced with the
contents of the user and password fields below. Using variables is the
recommended procedure, as this prevents values in the ADO string from being
output in clear text. But it is also possible to enter the values manually, in
which case you should leave the user and password fields empty.
c. Trusted_Connection=No; optional parameter for SQL authentication. In
order for the SQL server to identify the Avira AntiVir Exchange server as
Trusted Server, enter ’Trusted_Connection=No;’ manually (no Avira
AntiVir Exchange variable available).
d. Initial Catalog=[DBCatalog]; mandatory parameter, which sets the
database to be used. Enter the parameter ’Initial Catalog=’ manually
in the string and set the Avira AntiVir Exchange variable Database. If using
the SQL server for the Quarantine, the variable [DBCatalog] will be
replaced with the name of the database set under Quarantine - Properties in
Avira AntiVir Exchange 7
48