>>SELECT a.* FROM OPENROWSET('VFPOLEDB.1', 'd:\data\mydbc.dbc';;, 'SELECT * FROM mytable where type ="CM"') AS a
>
>Anthony,
>
>Have you tried instead setting up a linked server that uses OLE DB to access the data and then using OPENQUERY()?
>
>Laterness,
>Jon

Openquery() gives me the same error.
Openquery() and openrowset() works on another sql machine.
Maybe I have an install problem?