Did you install VFP OLE DB provider on the PC where SQL Server runs? What's SQL Server version?
>I'm Trying to link server Visual FoxPro with OleDB, The Link was created without a problem, but when I try to query the any table I get the following error:
>
>Could not create an instance of OLE DB provider 'VFPOLEDB'.
>
>This is what I am trying:
>SELECT * FROM OPENQUERY(VFP,'SELECT * FROM TableName')
>
>SELECT * FROM VFP...SELECT * FROM TableName
>
>But none of them work.
>
>Using ODBC to link it, works fine, but not with OleDB.
>
--sb--