Partager via


Classe SMOServerConn

Contains the methods and properties used by SMO connections.

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Dts.ManagedConnections
Assembly :  Microsoft.SqlServer.ManagedConnections (en Microsoft.SqlServer.ManagedConnections.dll)

Syntaxe

'Déclaration
<DtsConnectionAttribute(ConnectionType := "SMOServer", LocalizationType := GetType(SMOServerConn),  _
    ConnectionContact := "Microsoft Corporation", UITypeName := "Microsoft.DataTransformationServices.Design.SMOServerConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")> _
Public Class SMOServerConn _
    Inherits ConnectionManagerBase _
    Implements IDTSComponentPersist
'Utilisation
Dim instance As SMOServerConn
[DtsConnectionAttribute(ConnectionType = "SMOServer", LocalizationType = typeof(SMOServerConn), 
    ConnectionContact = "Microsoft Corporation", UITypeName = "Microsoft.DataTransformationServices.Design.SMOServerConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=10.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=10.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=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")>]
type SMOServerConn =  
    class
        inherit ConnectionManagerBase
        interface IDTSComponentPersist
    end
public class SMOServerConn extends ConnectionManagerBase implements IDTSComponentPersist

Le type SMOServerConn expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique SMOServerConn() () () () Initializes a new instance of the SMOServerConn class.
Méthode publique SMOServerConn(Boolean, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, and password.
Méthode publique SMOServerConn(Boolean, String, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, password, and server.

Haut de la page

Propriétés

  Nom Description
Propriété publiqueMembre statique ConnectionDescription Gets the description of the connection manager for the SMO connection.
Propriété publiqueMembre statique ConnectionDisplayName Returns the localized display name of the connection.
Propriété publique ConnectionString Gets or sets the connection string for the SMO connection. (remplace ConnectionManagerBase. . :: . .ConnectionString.)
Propriété publique Password Sets the password for the connection, if you do not use Windows Authentication.
Propriété publique ProtectionLevel Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. (hérité de ConnectionManagerBase.)
Propriété publique SqlServerName Gets or sets a String that contains the name of the SQL Server to which you want to make the SMO connection.
Propriété publique SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. (hérité de ConnectionManagerBase.)
Propriété publique UserName Gets or sets the user name for the connection, if you do not use Windows Authentication.
Propriété publique UseWindowsAuthentication Gets or sets a Boolean that indicates if Windows Authentication is used for the connection.
Propriété publique Version Returns the version of this connection manager. (hérité de ConnectionManagerBase.)

Haut de la page

Méthodes

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

Haut de la page

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.