SMOServerConn Class

Article
2013-04-26

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

The SMOServerConn type exposes the following members.

Constructors

	Name	Description
	SMOServerConn()	Initializes a new instance of the SMOServerConn class.
	SMOServerConn(Boolean, String, String)	Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, and password.
	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
	ConnectionDescription	Gets the description of the connection manager for the SMO connection.
	ConnectionDisplayName	Returns the localized display name of the connection.
	ConnectionString	Gets or sets the connection string for the SMO connection. (Overrides ConnectionManagerBase.ConnectionString.)
	Password	Sets the password for the connection, if you do not use Windows Authentication.
	ProtectionLevel	Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. (Inherited from ConnectionManagerBase.)
	Scope	Gets the DTS connection manager scope for this ConnectionManagerBase object. (Inherited from ConnectionManagerBase.)
	SqlServerName	Gets or sets a String that contains the name of the SQL Server to which you want to make the SMO connection.
	SupportsDTCTransactions	Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. (Inherited from ConnectionManagerBase.)
	UserName	Gets or sets the user name for the connection, if you do not use Windows Authentication.
	UseWindowsAuthentication	Gets or sets a Boolean that indicates if Windows Authentication is used for the connection.
	Version	Returns the version of this connection manager. (Inherited from ConnectionManagerBase.)

Top

Methods

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

Share via