PI OLEDB Enterprise-specific initialization properties

Allow Expensive

If set to TRUE, expensive SQL commands can be executed.

Allow Expensive = False; (default)

Allow Expensive = True;

Always Return Rowset

If set, all SQL commands return rowset. DML statements return the number of rows affected by the execution.

Always Return Rowset = False; (default)

Always Return Rowset = True;

Cancel On Low Resources

Cancels query execution if available memory pages reach a critical level (greater than five percent).

Cancel On Low Resources = False; (default)

Command Timeout

Command timeout in seconds. Overrides the DBPROP_COMMANDTIMEOUT property.

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

Command Timeout = 60;

Defer Execution

If set, the execution of requests that would ask for all table rows is deferred to the first access to the resulting rowset data.

Defer Execution = False; (default)

Defer Execution = True;

Disable Server Selection

If set, the server combo box in the login dialog is disabled. This prevents users from changing the server during the connection procedure.

Disable Server Selection = False; (default)

Disable Server Selection = True;

Embed Errors

If set, embed error messages in the value column.

Embed Errors = False; (default)

Embed Errors = True;

Function Errors As NULL

If set to TRUE, SQL functions that reach an error state will return NULL.

Function Errors As NULL = False; (default)

Ignore Errors

If set, an error retrieving a value will not cause the whole query to fail. Instead the row in error will be omitted.

Ignore Errors = False; (default)

Ignore Errors = True;

Integers as Value

If set, integer point values are returned in the value column of the picomp and piinterp tables.

Integers as Value = False; (default)

Integers as Value = True;

Keep Default Ordering

If set, the returned table data is ordered according to the criteria defined by the table metadata. If not set, the returned data might not keep this ordering. Setting this property to FALSE can speed up the query execution.

Keep Default Ordering = True; (default)

Keep Default Ordering = False;

Log File

Full log file path/name.

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

Log Level

Log level. Determines what information is to be logged. (For details, see Activate logging.)

Log Level = 0; (default)

Log Level = 1;

Optimization Log Limit

Logging of optimization criteria is limited to the first n parameters. This reduces log file size and improves readability. It should only be increased for optimization troubleshooting.

Optimization Log Limit = 100; (default)

Server Log

Log file name. When specified, this overrides the log file property with system defined path and log file name.

Note: must be a valid file name

Server Log = PIOLEDBENT_trcl.log

Shorten Primary Keys

If set, the maximum length of string primary key columns is shortened to 255 characters. Microsoft Access does not support string primary keys longer than 255 characters. This property allows you to overcome this restriction.

Shorten Primary Keys = False; (default)

Shorten Primary Keys = True;

Time as Double

If set, time columns use double precision floating-point number as the underlying data type (values are in seconds). This property increases the time precision to subseconds.

Time as Double = False; (default)

Time as Double = True;

Time Zone

Time zone used for parsing of timestamp literals and for rendering of timestamp column values.

Time Zone = Local; (default)

Time Zone = UTC;