• Article

DataSource Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object.DataSource [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    An OLE DB provider-defined string

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDataSource(SQLDMO_LPBSTR pRetVal);
HRESULT SetDataSource(SQLDMO_LPCSTR NewValue);

Note

SQL Distributed Management Objects (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 using SysFreeString.

Remarks

The DataSource property 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 the OLE DB provider documentation.

Applies To:

LinkedServer Object