Source_DSN_Suffix Property

Source_DSN_Suffix Property

This property contains a string that is appended to the Source_DSN property value when creating or connecting to a local cube. This property's value is set when a session is established, and it can be reused but not changed during the session.

Property Name

Source_DSN_Suffix

Property ID

DBPROP_MSMD_SOURCE_DSN_SUFFIX

Remarks

This property is useful for separating data permanently stored in the local cube file from data used only for the session, such as the user account and password, because this property's value is not stored in the local cube file. Its primary purpose is to specify a user ID and password that the relational data source uses to create or access a local cube. If this property is used when you create a local ROLAP cube, it may also be required when you later connect to the cube. For example, if you specify a user account and password in this property when creating a local ROLAP cube, you must specify them in this property for each subsequent connection to the local ROLAP cube file.

See Also

Source_DSN Property