OLEDBProviderInfos collection vs Connections -
06-13-2005
, 08:41 AM
I have two questions:
1) Why aren't the available DTS providers (connection Icons in Designer)
listed in the OLEDBProviderInfos collection of the Application object?
2) Is there some other way to itterate through the providers that are
represented by the icons in the DTS Designer?
Background Information for the Questions:
I am writing an application that dynamically builds a DTS package and
executes it. It is basically a wizard that starts with defining a data
source. I wanted to provide a combo box with a list of available Providers. I
used the Application object to obtain a list of OLEDBProviders but have found
that several of the provides used by the connection icons in the DTS Designer
are not registered as OLEDB Providers.
I have created sample packages with each connection type using the designer
and have saved them to a VB file so I can "manually" create the combo box
entries, but it would be nice to find a way to make the application less
fragile by allowing it to iterate the available DTS providers. |