I have a SQL instance which has a linked server to a Fox Pro instance via OLE. I can query it within SQL Management Studio without issue. If I use SQLCMD via a scheduled task to query it, I get the following error:
Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "LINKEDSERVERNAME".
I turned on In Process on the OLE Provider but that didn't make a difference, any ideas?