Classe SMOServerConn
Contains the methods and properties used by SMO connections.
Hiérarchie d'héritage
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime. . :: . .ConnectionManagerBase
Microsoft.SqlServer.Dts.ManagedConnections..::..SMOServerConn
Espace de noms : Microsoft.SqlServer.Dts.ManagedConnections
Assembly : Microsoft.SqlServer.ManagedConnections (en Microsoft.SqlServer.ManagedConnections.dll)
Syntaxe
'Déclaration
<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
'Utilisation
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
Le type SMOServerConn expose les membres suivants.
Constructeurs
Nom | 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. |
Haut de la page
Propriétés
Nom | 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. (remplace 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. (hérité de 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. (hérité de 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. (hérité de ConnectionManagerBase.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
AcquireConnection | Establishes the SMO connection and returns a connection object. (remplace ConnectionManagerBase. . :: . .AcquireConnection(Object).) | |
CanUpdate | Gets or sets a Boolean that determines whether a connection manager supports upgrading the connection XML to a newer version. (hérité de ConnectionManagerBase.) | |
Equals | Determines whether two object instances are equal. (hérité de DtsObject.) | |
Finalize | (hérité de Object.) | |
GetHashCode | Returns the hash code for this instance. (hérité de DtsObject.) | |
GetType | (hérité de Object.) | |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method. | |
MemberwiseClone | (hérité de Object.) | |
ReleaseConnection | Frees the connection established during AcquireConnection. Called at design time and run time. (hérité de 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. (hérité de ConnectionManagerBase.) | |
ToString | (hérité de Object.) | |
Update | Updates the XML persisted by a previous version of the connection manager. (hérité de ConnectionManagerBase.) | |
Validate | Validates the connection and returns an enumeration that indicates success or failure. (hérité de ConnectionManagerBase.) |
Haut de la page
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.