Enumerating and Initializing OLE DB for OLAP Data Source Objects

OLE DB enumerators are used to locate MDPs and create OLE DB data source objects, which are then used to create session objects, and so on. In this respect, initializing an MDP is no different from initializing any other OLE DB provider.

However, the consumer needs to easily determine the type of a given data source. For example, a data source “locator” may implement option buttons, which allow the user to browse for TDPs, MDPs, or both TDPs and MDPs. It is useful for the provider to expose data source types at enumeration time.

The following is a new value added to the SOURCES_TYPE column in the SOURCES rowset for OLE DB:

#define DBSOURCETYPE_DATASOURCE_MDP 3

Furthermore, the DBSOURCETYPE_DATASOURCE value is renamed as follows:

#define DBSOURCETYPE_DATASOURCE_TDP DBSOURCETYPE_DATASOURCE

The consumer uses these values to determine whether it is interacting with a TDP or an MDP.