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