%META:TOPICPARENT{name="OLEDBObjectsInterfaces"}% ===Initialization Properties Used=== The following lists the initialization properties currently used by the OpenLink Provider. Any properties not listed are not used by the OpenLink Provider. Table: 5.7.4.1.1. OLE-DB Initialization Properties | *Property* | *Description* | |DBPROP_AUTH_PASSWORD| Passed as the value of the PWD keyword in SQLDriverConnect.| |DBPROP_AUTH_USERID| Passed as the value of the UID keyword in SQLDriverConnect.| |DBPROP_INIT_CATALOG| Sets the initial catalog for data sources which recognise catalogs.| |DBPROP_INIT_DATASOURCE| Passed as the value of the DSN keyword in SQLDriverConnect.| |DBPROP_INIT_HWND|Passed as the value of the hwnd argument in SQLDriverConnect.| |DBPROP_INIT_MODE|Mapped to the ODBC connect option SQL_ACCESS_MODE.| |DBPROP_INIT_PROMPT|Passed as the value of the fDriverCompletion parameter in SQLDriverConnect.| |DBPROP_INIT_PROVIDERSTRING| Specifies extended properties for controlling ODBC Cursor Library usage (through the 'Cursors' keyword) and the whether bookmarks are exposed by default on rowsets (through the 'BookmarkDefault' keyword).| |DBPROP_INIT_TIMEOUT| Mapped to the ODBC connect option SQL_LOGIN_TIMEOUT.| ===Setting and Getting Provider Properties=== The data source object is the first object created when a consumer instantiates the provider by calling CoCreateInstance. The data source object provides the starting point for communications between the provider and consumer. For example, a consumer can call CoCreateInstance and request an IDBInitialize interface pointer to instantiate a data source object. The provider has a CLSID (class ID) that is stored in the Windows Registry. The consumer can use this CLSID with CoCreateInstance to instantiate the data source object. The OpenLink provider setup program registers the OpenLink provider in the Windows Registry. The data source object is responsible for setting and returning information about the properties supported by the provider and exposing the list of supported keywords and literals. This functionality is supported through the mandatory IDBProperties interface and the optional IDBInfo interface. The IDBProperties interface contains three methods: * **GetProperties** returns the list of properties currently set on the data source object. * **GetPropertyInfo** returns information about supported rowset and data source properties. * **SetProperties** sets the properties on the data source object. The IDBInfo interface contains two methods: * **GetKeywords** returns a list of supported keywords. * **GetLiteralInfo** returns information about literals used in text commands.