DataSource Property (SQL-DMO)

The DataSource property specifies the OLE DB data source part of initialization properties used by a provider to locate a data store.

Applies To

LinkedServer Object

Syntax

object.DataSource [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	OLE DB provider-defined string

Remarks

DataSource provides a value for the OLE DB initialization property DBPROP_INIT_DATASOURCE. Initialization properties are set for the provider when an attempt is made to connect to the OLE DB data source referenced by the LinkedServer object. For more information about values for the DataSource property, see your OLE DB provider documentation.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDataSource(SQLDMO_LPBSTR pRetVal);

HRESULT SetDataSource(SQLDMO_LPCSTR NewValue);

Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.