You cannot use VFP ODBC driver in OPENROWSET directly, only through MS OLE DB provider for ODBC. So change it to
SELECT a.*
FROM OPENROWSET('MSDASQL', 'DRIVER={Microsoft Visual FoxPro Driver};
Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
SourceDB=f:\accounts\data\cards.dbc;SourceType=DBC;',
'SELECT * FROM mediatype') AS a
Or use VFP OLE DB provider
SELECT a.*
FROM OPENROWSET('VFPOLEDB.1',
'f:\accounts\data\cards.dbc';;,
'SELECT * FROM mediatype') AS a
Notice double ";" semicolon after the database name.
>Sergey, I am trying to run a simple query like
>SELECT a.*
>FROM OPENROWSET('Microsoft Visual FoxPro Driver', 'DRIVER={Microsoft Visual FoxPro Driver};Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;SourceDB=f:\accounts\data\cards.dbc;SourceType=DBC;', cards.mediatype) AS a
>
>for my existing on f:\accounts\data network drive cards database.
>However it gives me an error like
>Could not locate registry entry for OLE DB provider 'Microsoft Visual FoxPro Driver'.
>
>What am i doing wrong?
--sb--