PI OLEDB Connection parameters

Default Timestep

Time step for the interpolation table and aggregate tables in the archive catalog.

Default Timestep = 1h; (default)

Default Timestep = 1d;

Command Timeout

Timeout in seconds. Overrides the DBPROP_COMMANDTIMEOUT property.

Command Timeout = -1; (default; not set)

Command Timeout = 60;

Connection Timeout

Timeout in seconds.

Connect Timeout = 15;

Current Time Precision

Precision in number of decimal places in the second fraction. The maximum precision is 3 (milliseconds).

Current Time Precision = 0; (default)

Current Time Precision = -1; (maximum precision)

Source Time Zone

Time zone used to parse timestamp literals and render timestamp column values.

Time Zone = Local; (default)

TimeZone = UTC;

TimeZone = Server;

Log Level

The amount of information to be logged.

Log Level = 0; (default)

Log Level = 1;

Log File

Full log file path/name.

Log File = C:\Temp\Log\PIOLEDB.log;

Defer Execution

Defer execution of requests that ask for all table rows until the first access of the resulting rowset data.

This property enables execution of INSERT commands on linked SQL Servers, based on PI OLEDB and usage of DTS.

Defer Execution = False; (default)

Defer Execution = True;

Disable Server Selection

Disable the server selection box in the login dialog to prevent users from changing the server during connection.

Disable Server Selection = False; (default)

Disable Server Selection = True;

Use Identifier Prefixes

Prefix names of columns, tables, and catalogs with 'pi_' to avoid collisions with client application keywords.

Identifier Prefixes = False; (default)

Identifier Prefixes = True;

Integers as Value

Return integer point values in the picomp table value column.

Integers as Value = False; (default)

Integers as Value = True;

Keep Default Ordering

Order returned data according to the criteria defined by table metadata.

If not set, returned data might not maintain this order, but query execution times may be improved.

Keep Default Ordering = True; (default)

Keep Default Ordering = False;

Shorten Primary Keys

Reduce the maximum length of string primary key columns to 255 characters.

Use this property to overcome restrictions in Microsoft Access on primary keys longer than 255 characters.

Shorten Primary Keys = False; (default)

Shorten Primary Keys = True;

Support PI Wildcards

Support PI-specific pattern wildcards ('*', '_') using the LIKE operator.

Support PI Wildcards = True; (default)

Support PI Wildcards = False;

Time as Double

Use double precision floating-point numbers as the underlying data type for time columns (values are in seconds), increasing time precision to subseconds.

Time as Double = False; (default)

Time as Double = True;

Timestamp Interval Start

Use the interval start time to identify aggregates in the archive catalog, instead of interval end time.

Timestamp Interval Start = False; (default)

Timestamp Interval Start = True;