Data source objects are described in the OLE DB specification.
Cube information is cached for each data source, and may not reflect current data for multi-user data sources.
The following table lists the properties used for initialization:
Property | Description |
DBPROP_INIT_DATASOURCE | Name of server machine or local cube file |
DBPROP_INIT_CATALOG | Name of default (initial) database (catalog) |
DBPROP_AUTH_USERID | Ignored in this release |
DBPROP_AUTH_PASSWORD | Ignored in this release |
DBPROP_INIT_ASYNCH | Used for asynchronous initialization |
DBPROP_MSMD_CREATE_CUBE | (optional) CREATE CUBE statement to create a local cube file Otherwise: NULL |
DBPROP_MSMD_INSERT_INTO | (optional) INSERT INTO statement to populate a local cube file created with CREATE CUBE Otherwise: NULL |
DBPROP_MSMD_SOURCE_DSN | ODBC connection string, OLEDB connection string, or DSN for source relational database, used only when creating a local cube file |
DBPROP_MSMD_SOURCE_UID | ODBC UID for source relational database, used only when creating a local cube file |
DBPROP_MSMD_SOURCE_PWD | ODBC PWD for source relational database, used only when creating a local cube file |
DBPROP_INIT_PROVIDERSTRING | A predefined string containing other initialization properties. |
MSMD_USEEXISTINGFILE | If the first character of this string is Y, T, or a numeric digit other than 0, CREATE CUBE and INSERT INTO properties will be ignored. |
MSMD_ARTIFICIALDATA | If the first character of this string is Y, T, or a numeric digit other than 0, artificial aggregate values will be calculated using a simple algorithm instead of calculating real values. |
IDBInfo is not fully tested.
IPersistFile is not fully supported
Asysnchronous initialization supports polling only through IDBAsynchStatus. The IDBAsynchNotify connection point is not supported.