Use additional special properties of the DataSource object to declare connection criteria specific to PivotTable® Service. For example, you must specify at the time of session initialization whether you want to connect to an OLAP server or create a new local cube. For more information, see the OLE DB documentation.
PivotTable Service uses the DataSource properties in the following table. These properties and related constants are defined in a C++ header file. By default, this file is installed as ..\Program Files\OLAP Services\Samples\Include\msmd.h.
| Property ID | Property Name | Description |
|---|---|---|
| DBPROP_AUTH_PASSWORD | Password | Reserved for future use. |
| DBPROP_AUTH_USERUID | User ID | Reserved for future use. |
| DBPROP_INIT_ASYNCH | Asynchronous Processing | Used for asynchronous initialization. |
| DBPROP_INIT_CATALOG | Initial Catalog | Name of initial database (catalog). |
| DBPROP_INIT_DATASOURCE | Data Source | Name of server computer or local cube file. |
| DBPROP_INIT_LCID | Locale Identifier | The locale ID of preference for the client. |
| DBPROP_INIT_PROVIDERSTRING | Source OLE DB Provider | A predefined string containing other initialization properties. |
| DBPROP_MSMD_AUTOSYNCHPERIOD | Auto Synch Period | Controls the frequency (in milliseconds) of client/server synchronization. |
| DBPROP_MSMD_CACHEPOLICY | Cache Policy | Reserved for future use. |
| DBPROP_MSMD_COMPARECASENOTSENSITIVESTRINGFLAGS | CompareCaseNotSensitiveStringFlags | Adjusts case-insensitive string comparisons for a specified locale. |
| DBPROP_MSMD_COMPARECASESENSITIVESTRINGFLAGS | CompareCaseSensitiveStringFlags | Adjusts case-sensitive string comparisons for a specified locale. |
| DBPROP_MSMD_CREATE_CUBE | CREATECUBE | CREATE CUBE statement to create a local cube file. |
| DBPROP_MSMD_DATA_CACHE_SIZE | Client Cache Size | Controls the amount of memory used by client cache. |
| DBPROP_MSMD_DEFAULT_ISOLATION_MODE | Default Isolation Mode | Controls whether the isolation level is “isolated” or determined by the cursor type requested by the rowset properties. |
| DBPROP_MSMD_EXECLOCATION | Execution Location | Determines the location of query resolution: the client, server, or a combination of both. |
| MDPROP_MSMD_INSERT_INTO | INSERTINTO | INSERT INTO statement to populate a local cube file created with the CREATE CUBE statement. |
| DBPROP_MSMD_LARGE_LEVEL_THRESHOLD | Large Level Threshold | Determines the definition of “large” level for client/server handling of level members. |
| DBPROP_MSMD_READ_ONLY_SESSION | Read Only Session | Reserved for future use. |
| DBPROP_MSMD_SOURCE_DSN | SOURCE_DSN | OLE DB connection string, ODBC connection string, or ODBC DSN for the source relational database; used only when creating a local cube file. |
| DBPROP_MSMD_SOURCE_DSN_SUFFIX | SOURCE_DSN_SUFFIX | A string appended to the DBPROP_MSMD_SOURCE_DSN property when creating or connecting to a local cube. |
| DBPROP_MSMD_USEEXISTINGFILE | UseExistingFile | Determines whether a local cube file is overwritten if the connection string contains CREATE CUBE and INSERT INTO statements. |
| DBPROP_MSMD_WRITEBACK_TIMEOUT | Writeback Timeout | Maximum amount of time (in seconds) the client will attempt to communicate updates to a write-back table on the server. |