2.5.8 Connections Collection
The Connections collection is stored as part of the Package object.
The per-item properties of the Connections collection are listed in the following table.
|
Property |
Type |
Description |
|---|---|---|
|
Name |
BSTR |
Specifies the name of the connection. |
|
ID |
LONG |
Specifies the connection ID. |
|
Reusable |
BOOL |
Specifies whether the connection is reusable. If TRUE, the connection is reusable. If FALSE, the connection is not reusable. |
|
ConnectImmediate |
BOOL |
Specifies whether an immediate connection is made. If TRUE, an immediate connection is made. If FALSE, an immediate connection is not made. |
|
DataSource |
BSTR |
Specifies the name of the data source. |
|
UserID |
BSTR |
Specifies the user ID or user name to use when making a connection. |
|
Password |
BSTR |
Specifies the password to use when making a connection. |
|
ConnectionTimeout |
LONG |
Specifies the number of seconds to wait for a connection. |
|
ProviderID |
BSTR |
Specifies the program ID of the OLE DB provider. |
|
Catalog |
BSTR |
Specifies the name of the catalog for a connection. |
|
UseTrustedConnection |
BOOL |
Specifies whether to use a trusted connection.<32> |
|
Description |
BSTR |
Specifies the connection description. |
|
UseDSL |
BOOL |
Specifies whether to use a Data Source Link (DSL) file. If TRUE, DSL is used. If FALSE, DSL is not used. |
|
UDLPath |
BSTR |
Specifies the full path to the DSL file to be used to create a connection. |
The persistent collection contains connection properties, persisted as "Connection Properties". "Connection Properties" contains provider-specific OLE DB connection properties.