Any suggestions for proper select statement syntax using the 4 part naming convention. I am currently trying to access FoxPro 2.6 dos table. No schema, attempting to access the Lot.Dbf in h:\as2001\co1. Linked server name =SVR. Tried query using the following 4 part name.
SVR.h:\as2001\co1..lot

also used:
SVR.[h.\as2001\co1]..Lot

Both return the error: "Unrecognized phrase in keyword" from the ODBC driver.