Connection string format

Initial Catalog

The initial catalog.

Note: By default, the data model for PI SQL Client consists of one catalog - Master. This catalog contains a set of tables and table-valued functions. For information about how to create other catalogs, see the PI SQL Commander Lite User Guide.

Initial Catalog=Master; (default)

Integrated Security

Name of the authentication service.

Setting the property to SSPI (Security Service Provider Interface) invokes a trusted connection.

Integrated Security=SSPI; (default)

Protocol Order

Order of the protocols used.

Protocol Order=Https/Soap:5464,NetTcp:5465; (default)

Query Date

Defaults to Latest. Also supports now and PI time literals. See the PI Server topic, PI time.

Query Date='now';

Query Date='-1d';

Time Zone

Defaults to Local. You can set a specific time zone used for parsing of timestamp literals and for rendering of timestamp column values.

Time Zone=(UTC-08:00) Pacific Time (US & Canada)

Time Zone=Local

User ID, User, or UID

The User ID to use of authentication when you log on to the data source.

User ID=mydomain\user1;

Password or Pwd

The password to use for authentication when you log on to the data source.

Password=PI;

FileDSN

Specify an ODBC File data source to use for the connection.

FileDSN=MyFile.dsn;

Variant as String

True or False (default). Original Variant columns will be exposed as String columns.

Variant as String=True;

GUID as String

True or False (default). Original GUID columns as String columns.

GUID as String=True;

Maximum string size

Specifies the maximum string size to be returned, because some clients may not handle long string correctly. Use 0 for unlimited size. Defaults to 4000.

Maximum string size=2000;

Command Timeout

Enter the command timeout in seconds. Enforces the command timeout for all commands, even if ODBC statement query timeout was specified.

Command Timeout=20;