General OLE DB initialization properties

OLE DB provider ProgID

Provider

Provider = PIOLEDBENT;

DBPROP_AUTH_ INTEGRATED

Name of the authentication service

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

Integrated Security

Integrated Security = ; (default)

Integrated Security = SSPI;

DBPROP_AUTH_ USERID

User name

User ID

User ID = piadmin;

DBPROP_AUTH_ PASSWORD

Password

Password

Password = PI;

DBPROP_INIT_ CATALOG

Initial catalog (database)

Initial Catalog = Configuration;

Initial Catalog = Configuration;

DBPROP_INIT_ DATASOURCE

Name of the PI AF server that is the data source

Data Source

Data Source = localhost;

DBPROP_INIT_ HWND

Window handle from the calling application - used as a parent window of the dialog that prompts for the missing information

This property is not persisted in the connection string

N/A

DBPROP_INIT_ PROMPT

Prompt mode - designates if the provider should ask for the missing information

This property is not persisted in the connection string

N/A

DBPROP_INIT_ PROVIDERSTRING

Provider-specific properties

Extended Properties

Extended Properties = "Always Return Rowset = True;"

DBPROP_INIT_ TIMEOUT

Connection timeout in seconds

This property is currently not used

You must use PI System Explorer to change the default connection timeout

Connect Timeout

Connect Timeout = 0;