Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Contains the methods and properties used by SMO connections.
Vererbungshierarchie
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
Der SMOServerConn-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
![]() |
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. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
![]() ![]() |
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. (Überschreibt 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. (Geerbt von ConnectionManagerBase.) |
![]() |
Scope | Gets the DTS connection manager scope for this ConnectionManagerBase object. (Geerbt von 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. (Geerbt von 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. (Geerbt von ConnectionManagerBase.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
![]() |
AcquireConnection | Establishes the SMO connection and returns a connection object. (Überschreibt ConnectionManagerBase.AcquireConnection(Object).) |
![]() |
CanUpdate | Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version. (Geerbt von ConnectionManagerBase.) |
![]() |
Equals | Determines whether two object instances are equal. (Geerbt von DtsObject.) |
![]() |
Finalize | (Geerbt von Object.) |
![]() |
GetHashCode | Returns the hash code for this instance. (Geerbt von DtsObject.) |
![]() |
GetType | (Geerbt von Object.) |
![]() |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. |
![]() |
MemberwiseClone | (Geerbt von Object.) |
![]() |
ReleaseConnection | Frees the connection established during AcquireConnection. Called at design time and run time. (Geerbt von 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. (Geerbt von ConnectionManagerBase.) |
![]() |
ToString | (Geerbt von Object.) |
![]() |
Update | Updates the XML persisted by a previous version of the connection manager. (Geerbt von ConnectionManagerBase.) |
![]() |
Validate | Validates the connection and returns an enumeration that indicates success or failure. (Geerbt von ConnectionManagerBase.) |
Zum Anfang
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
.gif)
.gif)
.gif)
.gif)