ConnectionManagerAdoNetClass ConnectionManagerAdoNetClass ConnectionManagerAdoNetClass Class

Definition

Represents a connection manager that utilizes .Net provider for the data connection.

public ref class ConnectionManagerAdoNetClass : Microsoft::SqlServer::Dts::Runtime::Wrapper::ConnectionManagerAdoNet, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerDatabaseParameters100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerInit100
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.Guid("58297D74-0AC9-4659-B8EE-D5B38CAA686F")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
public class ConnectionManagerAdoNetClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerAdoNet, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerInit100
Public Class ConnectionManagerAdoNetClass
Implements ConnectionManagerAdoNet, IDTSConnectionManagerDatabaseParameters100, IDTSConnectionManagerInit100
Inheritance
ConnectionManagerAdoNetClassConnectionManagerAdoNetClassConnectionManagerAdoNetClass
Attributes
Implements

Remarks

For more information, see ConnectionManager.

Constructors

ConnectionManagerAdoNetClass() ConnectionManagerAdoNetClass() ConnectionManagerAdoNetClass()

Initializes a new instance of the ConnectionManagerAdoNetClass class.

Properties

ConnectionString ConnectionString ConnectionString

Gets or sets the connection string used to establish a connection to a data source.

InitialCatalog InitialCatalog InitialCatalog

Gets or sets the initial catalog for the connection.

Password Password Password

Gets or sets the password for the connection.

ProtectionLevel ProtectionLevel ProtectionLevel

Gets or sets the level of encryption performed on sensitive data that is contained in the package.

RetainSameConnection RetainSameConnection RetainSameConnection

Gets or sets a Boolean that indicates whether the connection manager retains the same connection.

Scope Scope Scope

Gets the scope of the connection manager.

ServerName ServerName ServerName

Gets or sets the server name.

SupportsDTCTransactions SupportsDTCTransactions SupportsDTCTransactions

Gets a Boolean that indicates whether the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.

UserName UserName UserName

Gets or sets the username for the connection.

Methods

AcquireConnection(Object) AcquireConnection(Object) AcquireConnection(Object)

Creates an instance of the connection type.

GetConnectionForSchema() GetConnectionForSchema() GetConnectionForSchema()

Gets the connection for the schema.

InitializeConnectionManager(String, IDTSInfoEvents100, IDTSLogging100) InitializeConnectionManager(String, IDTSInfoEvents100, IDTSLogging100) InitializeConnectionManager(String, IDTSInfoEvents100, IDTSLogging100)

Initializes the properties of the connection manager instance using the given parameters.

ReleaseConnection(Object) ReleaseConnection(Object) ReleaseConnection(Object)

Frees the connection established during AcquireConnection(Object). Called at design time and runtime.

SetQualifier(String) SetQualifier(String) SetQualifier(String)

Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.

Validate(IDTSInfoEvents100) Validate(IDTSInfoEvents100) Validate(IDTSInfoEvents100)

Validates the connection and returns an enumeration that indicates success or failure.

Applies to