Compartir a través de


Clase SMOServerConn

Contains the methods and properties used by SMO connections.

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.SqlServer.Dts.ManagedConnections
Ensamblado:  Microsoft.SqlServer.ManagedConnections (en Microsoft.SqlServer.ManagedConnections.dll)

Sintaxis

'Declaración
<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
'Uso
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

El tipo SMOServerConn expone los siguientes miembros.

Constructores

  Nombre Descripción
Método público SMOServerConn() Initializes a new instance of the SMOServerConn class.
Método público SMOServerConn(Boolean, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, and password.
Método público SMOServerConn(Boolean, String, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, password, and server.

Arriba

Propiedades

  Nombre Descripción
Propiedad públicaMiembro estático ConnectionDescription Gets the description of the connection manager for the SMO connection.
Propiedad públicaMiembro estático ConnectionDisplayName Returns the localized display name of the connection.
Propiedad pública ConnectionString Gets or sets the connection string for the SMO connection. (Invalida ConnectionManagerBase.ConnectionString.)
Propiedad pública Password Sets the password for the connection, if you do not use Windows Authentication.
Propiedad pública ProtectionLevel Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. (Se hereda de ConnectionManagerBase.)
Propiedad pública Scope Gets the DTS connection manager scope for this ConnectionManagerBase object. (Se hereda de ConnectionManagerBase.)
Propiedad pública SqlServerName Gets or sets a String that contains the name of the SQL Server to which you want to make the SMO connection.
Propiedad pública SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. (Se hereda de ConnectionManagerBase.)
Propiedad pública UserName Gets or sets the user name for the connection, if you do not use Windows Authentication.
Propiedad pública UseWindowsAuthentication Gets or sets a Boolean that indicates if Windows Authentication is used for the connection.
Propiedad pública Version Returns the version of this connection manager. (Se hereda de ConnectionManagerBase.)

Arriba

Métodos

  Nombre Descripción
Método público AcquireConnection Establishes the SMO connection and returns a connection object. (Invalida ConnectionManagerBase.AcquireConnection(Object).)
Método público CanUpdate Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version. (Se hereda de ConnectionManagerBase.)
Método público Equals Determines whether two object instances are equal. (Se hereda de DtsObject.)
Método protegido Finalize (Se hereda de Object.)
Método público GetHashCode Returns the hash code for this instance. (Se hereda de DtsObject.)
Método público GetType (Se hereda de Object.)
Método público LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Método protegido MemberwiseClone (Se hereda de Object.)
Método público ReleaseConnection Frees the connection established during AcquireConnection. Called at design time and run time. (Se hereda de ConnectionManagerBase.)
Método público SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Método público SetQualifier Changes a qualifier on the connection manager after the connection manager has been created, but before it is run. (Se hereda de ConnectionManagerBase.)
Método público ToString (Se hereda de Object.)
Método público Update Updates the XML persisted by a previous version of the connection manager. (Se hereda de ConnectionManagerBase.)
Método público Validate Validates the connection and returns an enumeration that indicates success or failure. (Se hereda de ConnectionManagerBase.)

Arriba

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Dts.ManagedConnections