I am trying to implement linked servers to access some legacy VFP data.
I have created a linked server and I can access data using it when I run my select queries on the SQL box, but I running it remotely returns this:

OLE DB provider "VFPOLEDB" for linked server "specifications" returned message "Invalid path or file name.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "specifications".

I was told I have to use a SQL authentication to run LSs. Not sure what I need to do. Any idea out there?

Thanks