Freigeben über


SMOServerConn-Klasse

Contains the methods and properties used by SMO connections.

Vererbungshierarchie

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.ConnectionManagerBase
      Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn

Namespace:  Microsoft.SqlServer.Dts.ManagedConnections
Assembly:  Microsoft.SqlServer.ManagedConnections (in Microsoft.SqlServer.ManagedConnections.dll)

Syntax

'Declaration
<DtsConnectionAttribute(ConnectionType := "SMOServer", LocalizationType := GetType(SMOServerConn),  _
    ConnectionContact := "Microsoft Corporation", UITypeName := "Microsoft.DataTransformationServices.Design.SMOServerConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")> _
Public Class SMOServerConn _
    Inherits ConnectionManagerBase _
    Implements IDTSComponentPersist
'Usage
Dim instance As SMOServerConn
[DtsConnectionAttribute(ConnectionType = "SMOServer", LocalizationType = typeof(SMOServerConn), 
    ConnectionContact = "Microsoft Corporation", UITypeName = "Microsoft.DataTransformationServices.Design.SMOServerConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")]
public class SMOServerConn : ConnectionManagerBase, 
    IDTSComponentPersist
[DtsConnectionAttribute(ConnectionType = L"SMOServer", LocalizationType = typeof(SMOServerConn), 
    ConnectionContact = L"Microsoft Corporation", UITypeName = L"Microsoft.DataTransformationServices.Design.SMOServerConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")]
public ref class SMOServerConn : public ConnectionManagerBase, 
    IDTSComponentPersist
[<DtsConnectionAttribute(ConnectionType = "SMOServer", LocalizationType = typeof(SMOServerConn), 
    ConnectionContact = "Microsoft Corporation", UITypeName = "Microsoft.DataTransformationServices.Design.SMOServerConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")>]
type SMOServerConn =  
    class 
        inherit ConnectionManagerBase 
        interface IDTSComponentPersist 
    end
public class SMOServerConn extends ConnectionManagerBase implements IDTSComponentPersist

Der SMOServerConn-Typ macht folgende Elemente verfügbar.

Konstruktoren

  Name Beschreibung
Öffentliche Methode SMOServerConn() Initializes a new instance of the SMOServerConn class.
Öffentliche Methode SMOServerConn(Boolean, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, and password.
Öffentliche Methode SMOServerConn(Boolean, String, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, password, and server.

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche EigenschaftStatisches Element ConnectionDescription Gets the description of the connection manager for the SMO connection.
Öffentliche EigenschaftStatisches Element ConnectionDisplayName Returns the localized display name of the connection.
Öffentliche Eigenschaft ConnectionString Gets or sets the connection string for the SMO connection. (Überschreibt ConnectionManagerBase.ConnectionString.)
Öffentliche Eigenschaft Password Sets the password for the connection, if you do not use Windows Authentication.
Öffentliche Eigenschaft ProtectionLevel Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. (Geerbt von ConnectionManagerBase.)
Öffentliche Eigenschaft Scope Gets the DTS connection manager scope for this ConnectionManagerBase object. (Geerbt von ConnectionManagerBase.)
Öffentliche Eigenschaft SqlServerName Gets or sets a String that contains the name of the SQL Server to which you want to make the SMO connection.
Öffentliche Eigenschaft SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. (Geerbt von ConnectionManagerBase.)
Öffentliche Eigenschaft UserName Gets or sets the user name for the connection, if you do not use Windows Authentication.
Öffentliche Eigenschaft UseWindowsAuthentication Gets or sets a Boolean that indicates if Windows Authentication is used for the connection.
Öffentliche Eigenschaft Version Returns the version of this connection manager. (Geerbt von ConnectionManagerBase.)

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode AcquireConnection Establishes the SMO connection and returns a connection object. (Überschreibt ConnectionManagerBase.AcquireConnection(Object).)
Öffentliche Methode CanUpdate Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version. (Geerbt von ConnectionManagerBase.)
Öffentliche Methode Equals Determines whether two object instances are equal. (Geerbt von DtsObject.)
Geschützte Methode Finalize (Geerbt von Object.)
Öffentliche Methode GetHashCode Returns the hash code for this instance. (Geerbt von DtsObject.)
Öffentliche Methode GetType (Geerbt von Object.)
Öffentliche Methode LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Geschützte Methode MemberwiseClone (Geerbt von Object.)
Öffentliche Methode ReleaseConnection Frees the connection established during AcquireConnection. Called at design time and run time. (Geerbt von ConnectionManagerBase.)
Öffentliche Methode SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Öffentliche Methode SetQualifier Changes a qualifier on the connection manager after the connection manager has been created, but before it is run. (Geerbt von ConnectionManagerBase.)
Öffentliche Methode ToString (Geerbt von Object.)
Öffentliche Methode Update Updates the XML persisted by a previous version of the connection manager. (Geerbt von ConnectionManagerBase.)
Öffentliche Methode Validate Validates the connection and returns an enumeration that indicates success or failure. (Geerbt von ConnectionManagerBase.)

Zum Anfang

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Dts.ManagedConnections-Namespace