Using a Consumer Supplied Prompting Interface

The OpenLink provider does not display a prompting interface of its own for entering OLE DB specific connection information. It relies instead upon the application supplying it.

OLE DB provides several core components, one of which is the Data Link component. The Data Link component provides a default prompting interface and is used by numerous Microsoft applications. It typically includes a page displayed by the ‘All’ tab, which allows users to set values for all the Initialization properties supported by an OLE DB provider. The ‘Extended Properties’ property can be set on this page. For the OpenLink provider, you should enter key-value pairs for any supported extended properties you wish to set, such as:

”Cursors=Driver”