ConnectionManagerOleDbClass Class

Definition

Represents a connection manager that connects to a data source using OLE DB provider.

public ref class ConnectionManagerOleDbClass : Microsoft::SqlServer::Dts::Runtime::Wrapper::ConnectionManagerOleDb, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerDatabaseParameters100
public ref class ConnectionManagerOleDbClass : Microsoft::SqlServer::Dts::Runtime::Wrapper::ConnectionManagerOleDb, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerDatabaseParameters100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerManagedIdentity140
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.Guid("96A2155A-6C39-4F46-B5A4-EC0B63FA0655")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
public class ConnectionManagerOleDbClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerOleDb, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("5802D1B1-DCFC-4F1E-8ACD-388327A21A9C")]
public class ConnectionManagerOleDbClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerOleDb, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("14977E8C-BABD-438F-9C71-C57206CDE422")]
public class ConnectionManagerOleDbClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerOleDb, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerManagedIdentity140
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.Guid("96A2155A-6C39-4F46-B5A4-EC0B63FA0655")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
type ConnectionManagerOleDbClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerOleDb
    interface IDTSConnectionManagerDatabaseParameters100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("5802D1B1-DCFC-4F1E-8ACD-388327A21A9C")>]
type ConnectionManagerOleDbClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerOleDb
    interface IDTSConnectionManagerDatabaseParameters100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("14977E8C-BABD-438F-9C71-C57206CDE422")>]
type ConnectionManagerOleDbClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerOleDb
    interface IDTSConnectionManagerDatabaseParameters100
    interface IDTSConnectionManagerManagedIdentity140
Public Class ConnectionManagerOleDbClass
Implements ConnectionManagerOleDb, IDTSConnectionManagerDatabaseParameters100
Public Class ConnectionManagerOleDbClass
Implements ConnectionManagerOleDb, IDTSConnectionManagerDatabaseParameters100, IDTSConnectionManagerManagedIdentity140
Inheritance
ConnectionManagerOleDbClass
Attributes
Implements

Remarks

For more information, see ConnectionManager.

Constructors

ConnectionManagerOleDbClass()

Initializes a new instance of the ConnectionManagerOleDbClass class.

Properties

ConnectionString

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

ConnectUsingManagedIdentity
InitialCatalog

Gets or sets the initial catalog for the connection.

Password

Gets or sets the password for the connection.

ProtectionLevel

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

RetainSameConnection

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

Scope

Gets the scope of the connection manager.

ServerName

Gets or sets the server name.

SupportsDTCTransactions

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

UserName

Gets or sets the username for the connection.

Methods

AcquireConnection(Object)

Creates an instance of the connection type.

GetConnectionForSchema()

Gets the connection for the schema.

ReleaseConnection(Object)

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

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)

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

Applies to