Connection string

The connection string is a string that defines infobase options in the following format: <Option name>=<value>, where:

Option name is the option name;
Value is its value.

Options are separated by semicolons (";").
If a value contains spaces, enclose it in double quotation marks (").
The set of available options depends on the infobase mode: file or client/server.

The following options are available for file infobases:

File. The name of the directory where the infobase file is located.
Locale. The language (country) used for opening or creating the infobase. This list of available values is identical to the list of available values of the <FormatString> parameter of the Format method. This option is not mandatory. If it is not specified, the infobase regional settings are used instead.

The following options are available for client/server infobases:

Srvr. The 1C:Enterprise server name.

To ensure uninterrupted operation of client applications, you can specify multiple cluster addresses:

• You can use a list of comma-separated cluster addresses as a value for the Srvr option.
  Example: Srvr="Server1,Server2" or Srvr="Server1:1741,Server2:1741"
• In the dialog box for adding an infobase in a client appliaction, you can specify a list of comma-separated cluster addresses in the 1C:Enterprise server cluster field.
  Example: Server1,Server2 or Server1:1741,Server2:1741

Ref. The infobase name on the 1C:Enterprise server.
DBMS. The database server type, one of the following:

MSSQLServer,
PostgreSQL,
IBMDB2,
OracleDatabase.

DBSrvr. The database server name.
DB. The database name on the database server.
DBUID. The database server user name.
DBPwd. The database server user password. If the database server user password is not set, you can omit this option.
SQLYOffs. The date offset used to store dates in Microsoft SQL Server. Can vary from 0 to 2000. This option is not mandatory. If it is omitted, the value is set to 0.
Locale. The language (country), same as in the file mode.
CrSQLDB. Create a database if it does not exist. Available values are: Y (create a database) and N (do not create a database). The default value is N.
SchJobDn. Deny the execution of scheduled jobs in the created infobase. Available values are Y and N. The default value is N.
SUsr. The administrator name of the cluster where the initial image is to be created. Specify this option if the cluster has administrators specified and the operating system authentication is not available or not convenient for them.
SPwd. The cluster administrator password.

The following options are available for all infobases:

Usr. The user name.
Pwd. The password.
LicDstr. Allow acquisition of client licenses from the 1C:Enterprise server. The following values are available:

Y. Acquire a client license from the 1C:Enterprise server. If the client application has not acquired a software or hardware license from a local or network HASP keys, it attempts to acquire a client license from the 1C:Enterprise server.
N. Do not acquire a client license from the 1C:Enterprise server.
The default value is N.

Zn. Specifies a set of separators.

ZN=<Common attribute 1>,<Common attribute 2>,...,<Common attribute N>

<Common attribute> = [<+>|<->]<Common attribute value>

[<+>|<->] specifies attribute usage: "+" (default) means that the attribute is used, "-" means that the attribute is not used.

If a separator is not used, the value must be preceded by "-". If the first character in the separator value is + or -, replace it with ++ or -- respectively.

<Common attribute value> specifies the common attribute value. If the separator value includes a comma, replace it with two commas. If the separator value is missing but this separator is required, use the "+" character instead.

Separators are comma-separated.

Example:

"Zn=-FirstSeparator,+,---ThirdSeparator" means:

The first separator is disabled, its value is "FirstSeparator".

The second separator is enabled, its value is an empty string.

The third separator is disabled, its value is "-ThirdSeparator".

prmod. Starts 1C:Enterprise in the privileged session mode, which is available to authenticated users with administrator privileges. A record stating that the privileged session mode is set or cannot be set is added to the event log. prmod=1 sets the privileged mode.

A connection string is specified in the 1C:Enterprise startup dialog box, under the infobase list. It can be specified in the command-line option for mode selection CREATEINFOBASE, as a parameter of the CreateInitialImage() method.