Dela via


SMOServerConn Class

Contains the methods and properties used by SMO connections.

Inheritance Hierarchy

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=10.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=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

The SMOServerConn type exposes the following members.

Constructors

  Name Description
Public method SMOServerConn() Initializes a new instance of the SMOServerConn class.
Public method SMOServerConn(Boolean, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, and password.
Public method SMOServerConn(Boolean, String, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, password, and server.

Top

Properties

  Name Description
Public propertyStatic member ConnectionDescription Gets the description of the connection manager for the SMO connection.
Public propertyStatic member ConnectionDisplayName Returns the localized display name of the connection.
Public property ConnectionString Gets or sets the connection string for the SMO connection. (Overrides ConnectionManagerBase.ConnectionString.)
Public property Password Sets the password for the connection, if you do not use Windows Authentication.
Public property ProtectionLevel Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. (Inherited from ConnectionManagerBase.)
Public property SqlServerName Gets or sets a String that contains the name of the SQL Server to which you want to make the SMO connection.
Public property SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. (Inherited from ConnectionManagerBase.)
Public property UserName Gets or sets the user name for the connection, if you do not use Windows Authentication.
Public property UseWindowsAuthentication Gets or sets a Boolean that indicates if Windows Authentication is used for the connection.
Public property Version Returns the version of this connection manager. (Inherited from ConnectionManagerBase.)

Top

Methods

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

Top

Thread Safety

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