List ADO Providers

  • Thread starter Thread starter Burton Wilkins
  • Start date Start date
B

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
 
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
 
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.
__________________________________
 
Bill,

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

roy
 
Back
Top