>It doesn't work with Foxpro ODBC driver. See Message #550968 for workaround.
>You can try to use new VFP OLE DB provider.
>
< SNIP >

I just tried a link server with new VFP OLE DB provider and it allows direct reference. I created the lnked server "VFP_FREE" and than succesfuly ran

SELECT * FROM VFP_FREE...PROD