List ADO Providers

[Burton Wilkins]

Dear Authorities:

Could you please tell me how to get a list of all ADO Providers on a client
machine (without using the DataLink). I would assume they are within the
Registry but I don't know where to look.

Your answer to this question would be well appreciated.

Sincerely,


Burton G. Wilkins

 

[Roy Fine]

Burton,

There is no such thing as an ADO provider - there are OLEDB providers.

To enumerate all of the providers registered on a machine, you can use
CoCreateInstance and the CLSID of CLSID_OLEDB_ENUMERATOR to create an
instance of the root enumerator, and then construct a rowset and fetch the
providers. Here are a coupe of links:
http://msdn.microsoft.com/library/d...ating_data_source_objects_and_enumerators.asp

http://msdn.microsoft.com/library/d...y/en-us/oledb/htm/oledbenumerator_example.asp

Alternatively, you can scan the registry and discover them in your code.
Just look through HCEY_CLASSES_ROOT\CLSID for an entry that has the
InProcServer32 subkey as well as the OLE DB Provider and
VersionIndependentProgID subkeys. The values of the Prog ID and OLE DB
Provider should provide you with what you are looking for. Here is a link
that describes what to look for:

http://msdn.microsoft.com/library/d.../oledb/htm/oledbprovider_registry_entries.asp

regards
roy fine

 

[William \(Bill\) Vaughn]

There are OleDB .NET Data Providers, ODBC .NET Data Providers and Native
..NET data access providers. These are implemented in various DLLs that are
attached to typical ADO.NET applications and made part of the Framework.
(system.data.dll is one of them). ADO.NET does not require the use of
OleDb--as a matter of fact it's not even recommended except for JET and
other older data access engines.
In ADO.NET 2.0, there are new Framework classes to enumerate the providers
and the servers they expose.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Roy Fine]

Bill,

exactly - there are ADO.Net providers, and there are OLEDB providers - there
are no ADO providers.

roy