Location Property (LinkedServer)
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 Location property specifies the OLE DB location part of initialization properties used by a provider to locate a data store.
Syntax
object
.Location [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
The OLE DB provider-defined string
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetLocation(SQLDMO_LPBSTR pRetVal);
HRESULT SetLocation(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 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 the OLE DB provider documentation.