Класс SMOServerConn
Contains the methods and properties used by SMO connections.
Иерархия наследования
System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.ConnectionManagerBase
Microsoft.SqlServer.Dts.ManagedConnections.SMOServerConn
Пространство имен: Microsoft.SqlServer.Dts.ManagedConnections
Сборка: Microsoft.SqlServer.ManagedConnections (в Microsoft.SqlServer.ManagedConnections.dll)
Синтаксис
'Декларация
<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
'Применение
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
Тип SMOServerConn обеспечивает доступ к следующим элементам.
Конструкторы
Имя | Описание | |
---|---|---|
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. |
В начало
Свойства
Имя | Описание | |
---|---|---|
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. (Переопределяет 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. (Производный от ConnectionManagerBase.) | |
Scope | Gets the DTS connection manager scope for this ConnectionManagerBase object. (Производный от 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. (Производный от 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. (Производный от ConnectionManagerBase.) |
В начало
Методы
Имя | Описание | |
---|---|---|
AcquireConnection | Establishes the SMO connection and returns a connection object. (Переопределяет ConnectionManagerBase.AcquireConnection(Object).) | |
CanUpdate | Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version. (Производный от ConnectionManagerBase.) | |
Equals | Determines whether two object instances are equal. (Производный от DtsObject.) | |
Finalize | (Производный от Object.) | |
GetHashCode | Returns the hash code for this instance. (Производный от DtsObject.) | |
GetType | (Производный от Object.) | |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. | |
MemberwiseClone | (Производный от Object.) | |
ReleaseConnection | Frees the connection established during AcquireConnection. Called at design time and run time. (Производный от 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. (Производный от ConnectionManagerBase.) | |
ToString | (Производный от Object.) | |
Update | Updates the XML persisted by a previous version of the connection manager. (Производный от ConnectionManagerBase.) | |
Validate | Validates the connection and returns an enumeration that indicates success or failure. (Производный от ConnectionManagerBase.) |
В начало
Безопасность многопоточности
Любые открытые статический (Shared в Visual Basic) элементы этого типа потокобезопасны. Потокобезопасность с элементами экземпляров не гарантируется.
См. также
Справочник
Пространство имен Microsoft.SqlServer.Dts.ManagedConnections