How to enumerate OLE DB service providers?

Anyone know how to enumerate the installed OLE DB Providers. I've found out that it is probably the msdaenum.dll library that provides this service, but have found no information on how to access it using Visual Basic.

If you ever tried to get the properties of a connection object in the Data Environment window, you'll see that it is able to show you all the installed OLE DB Providers in your system - I'd like to be able to do the same in my own code.

The coolest programmers I know, don't know how to do it, so get famous and help me out :-)

Thanks in advance.

Best regards
Franz Hemmer
[email protected]

Bob Beauchemin & Jose Mojica from develop.com have come up with a solution to this problem. Email me if you want to get their getprovs.dll/tlb with sample code to use from Visual Basic.

Best regards
Franz Hemmer
[email protected]