Generate connection string

Forms a connection string from the passed data

Parameters

Function GenerateConnectionString(Val Address, Val Base = "", Val Login = "", Val Password = "", Val Port = "", Val WindowsAuth = False) Export

Parameter	CLI option	Type	Required	Description
Address	--addr	String	✔	Database server address and instance
Base	--db	String	✖	Name of the database to connect
Login	--login	String	✖	mssql user login
Password	--pass	String	✖	mssql user password
Port	--port	Number	✖	Server port
WindowsAuth	--trust	Boolean	✖	Use Windows authentication. The login and password will be ignored

Returns

String - MSSQL connection string

Advanced call ?

Parameter	Description
dontwait	Creates a background job and returns its data (for 1C and OneScript only)

tip

This function allows you to quickly assemble a basic connection string. In case you need more flexible configuration, you can also form (obtain) this connection string on your own (ADO format)

1C:Enterprise/OneScript code example

    Address  = "127.0.0.1";
    Login    = "bayselonarrend";
    Password = "12we...";

    Result = OPI_MSSQL.GenerateConnectionString(Address, , Login, Password);

Bash

    oint mssql GenerateConnectionString \
      --addr "127.0.0.1" \
      --login "SA" \
      --pass "***"

CMD/Bat

    oint mssql GenerateConnectionString ^
      --addr "127.0.0.1" ^
      --login "SA" ^
      --pass "***"

Result

"Server=127.0.0.1;User Id=bayselonarrend;Password=\"***\";"