dbTalk Databases Forums  

OLEDBProviderInfos collection vs Connections

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss OLEDBProviderInfos collection vs Connections in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
toryb
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.