• Article

SMOServerConn Members

Include Protected Members
Include Inherited Members

Contains the methods and properties used by SMO connections.

The SMOServerConn type exposes the following members.

Constructors

  Name Description
Public method SMOServerConn() Initializes a new instance of the SMOServerConn class.
Public method SMOServerConn(Boolean, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, and password.
Public method SMOServerConn(Boolean, String, String, String) Initializes a new instance of the SMOServerConn class, initializing the authentication mode, user name, password, and server.

Top

Methods

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

Top

Properties

  Name Description
Public propertyStatic member ConnectionDescription Gets the description of the connection manager for the SMO connection.
Public propertyStatic member ConnectionDisplayName Returns the localized display name of the connection.
Public property ConnectionString Gets or sets the connection string for the SMO connection. (Overrides ConnectionManagerBase.ConnectionString.)
Public property Password Sets the password for the connection, if you do not use Windows Authentication.
Public property ProtectionLevel Gets or sets a value, by using the DTSProtectionLevel enumeration, that enforces how the connection controls sensitive information. (Inherited from ConnectionManagerBase.)
Public property SqlServerName Gets or sets a String that contains the name of the SQL Server to which you want to make the SMO connection.
Public property SupportsDTCTransactions Returns a Boolean that indicates if the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. (Inherited from ConnectionManagerBase.)
Public property UserName Gets or sets the user name for the connection, if you do not use Windows Authentication.
Public property UseWindowsAuthentication Gets or sets a Boolean that indicates if Windows Authentication is used for the connection.
Public property Version Returns the version of this connection manager. (Inherited from ConnectionManagerBase.)

Top