Partager via


LinkedServer.ProviderString Property

Gets or sets the connection string used to connect to a linked server by way of the OLE DB Provider.

Espace de noms: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
Public Property ProviderString As String
public string ProviderString { get; set; }
public:
property String^ ProviderString {
    String^ get ();
    void set (String^ value);
}
/** @property */
public String get_ProviderString ()

/** @property */
public void set_ProviderString (String value)
public function get ProviderString () : String

public function set ProviderString (value : String)

Valeur de propriété

A String value that specifies the connection string used to connect to the link server by way of the OLE DB Provider.

Notes

The connection string is used as an alternative to setting the DataSource and ProviderName properties. Use the ProviderString property when complex connection settings are required. Refer to the OLE DB Provider settings for the particular product and provider for further information about the syntax for the connection string.

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Exemple

How to: Link to an OLE-DB Provider Server in Visual Basic .NET

Sécurité des threads

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

LinkedServer Class
LinkedServer Members
Microsoft.SqlServer.Management.Smo Namespace

Autres ressources

Using Linked Servers in SMO
Liaison des serveurs
sp_addlinkedserver (Transact-SQL)