>>>Is there a way, within VFP, to enumerate installed OLEDB providers on a workstation?
>>
>>An MSKB article implies you need to query the registry, that's the approach I'll take unless someone has a better idea:
>>
>>
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q280739>
>That would be the way to do it, unless you find some ready-made code. Any entry under HKEY_CLASSES_ROOT\CLSID that has a key of OLEDB_SERVICES would represent an OLEDB provider. Once there, the sub-key named "OLE DB Provider" will have the description. HTH
On further digging it looks like OLEDB already has sophisticated enumeration support:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbenumerating_data_source_objects_and_enumerators.aspIt even has an example on how to enumerate providers; unhappily it's in C++. I have no idea if this functionality is available from VFP.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up