Location Property (LinkedServer) (SQL-DMO)

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

Applies To

LinkedServer Object

Syntax

object.Location [= value]

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

Remarks

The Location property provides a value for the OLE DB initialization property DBPROP_INIT_LOCATION. 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 Location property, see your OLE DB provider documentation.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLocation(SQLDMO_LPBSTR pRetVal);

HRESULT SetLocation(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.