ADO - List Providers and DSN

[pcawdron]

Hi, I'm new to ADO.

Is there anyway to get ADO to list the OLE DB providers available?

Is there anyway to get ADO to list the DSN that have been previously set up?

So far I can get the DSN using ODBC API calls, so that's not critical. But I have no idea how to find out what OLE DB Providers are available.

Thanks for your help with this,

Peter

 

[chrissine]

Peter,

The easiest way to see the drivers available is to put the ADO control on your form, go to tab 'Connection String' select build and the first screen that appears lists all OLE DB providers. You can do what you want with the information from there.

Chris