is the VFP OLEDB provider installed on the machine that is hosting SQL Server? Remember that it will be SQL Server that is making the connection to the VFP database, not your workstation.
-Mike
>SELECT a.* FROM OPENROWSET('VFPOLEDB.1', 'd:\data\mydbc.dbc';;, 'SELECT * FROM mytable where type ="CM"') AS a
>
>returned this error:
>
>Server: Msg 7302, Level 16, State 1, Line 1
>Could not create an instance of OLE DB provider 'VFPOLEDB.1'.
>OLE DB error trace [Non-interface error: CoCreate of DSO for VFPOLEDB.1 returned 0x80040154].
>
>This works:
>SELECT a.*
> FROM OPENROWSET('MSDASQL' ,
> 'DRIVER={Microsoft Visual FoxPro Driver};
> Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
> SourceDB=d:\data\mydbc.dbc;SourceType=DBC',
> 'SELECT * FROM d:\data\mytable where type = "CM" ') AS a
>
>Please explain error message
>Thanks
>Anthony