DBPROP_MSMD_SOURCE_DSN_SUFFIX Property

A string appended to the DBPROP_MSMD_SOURCE_DSN property value when creating or connecting to a local cube.

Remarks

This property’s name, which is used in the connection string, is SOURCE_DSN_SUFFIX.

This property is used only when creating or connecting to a local cube. This property is useful for separating data persisted in the local cube file from data used only for the session. (Session data includes user account and password.) The property’s value is not stored in the local cube file.

If this property is used when you create a local ROLAP cube, it may also be required when you later connect to the local cube. For example, if you specify a user account and password in this property when you create a local ROLAP cube, and the data source still requires them when you later connect to the local cube, you must again specify them in this property.

This property’s value is used when a session is established, but the value cannot be changed during the session.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.