Export (0) Print
Expand All
Expand Minimize

Source_DSN Property

SQL Server 2000

Source_DSN Property

  New Information - SQL Server 2000 SP3.

This property contains the OLE DB connection string, ODBC connection string, or ODBC data source name (DSN) for the relational database or cube that will be used as the source for creating a local cube.

Security Note  When possible, use Windows Authentication.

Property Name

Source_DSN

Property ID

DBPROP_MSMD_SOURCE_DSN

Remarks

This property is used only when creating a local cube file.

You must use this property with the CreateCube property and the InsertInto property. When these three properties are used, they are always used together.

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

When creating and accessing a local cube that is created from a relational database, use the Source_DSN_Suffix property to pass security credentials, such as user name and password, to the relational database.

See Also

Source_DSN_Suffix Property

Show:
© 2014 Microsoft