Share via


LinkedServer.DataSource Property

Gets or sets the data source to be used when the linked server is made through a connection to an OLE DB provider.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property DataSource As String 
    Get 
    Set
'Usage
Dim instance As LinkedServer 
Dim value As String 

value = instance.DataSource

instance.DataSource = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
public string DataSource { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
public:
property String^ DataSource {
    String^ get ();
    void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
member DataSource : string with get, set
function get DataSource () : String 
function set DataSource (value : String)

Property Value

Type: System.String
A String value that specifies the data source on the linked server.

Remarks

The data source is defined in by the OLE DB provider. For the OLE DB provider for SQL Server, it is the server name.

Examples

Using Linked Servers in SMO

See Also

Reference

LinkedServer Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Linked Servers (Database Engine)

sp_addlinkedserver (Transact-SQL)