Sergey,

How would I connect to Fox 2.x tables? What would the provider string be?

Guy



>>The table is part of a database. I know the second syntax you give and using that syntax I get a result but that doesn't solve my original problem (combine 2 sql tables and 1 VFP table on a linked server)
>
>Hi Hans,
>
>We've two issues here:
>
>1. Four part name for a VFP table in DBC
>I just tested and it works for me. The linked server is setup with Provider string only

DRIVER={Microsoft Visual FoxPro Driver};
>Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
>SourceDB=\\Target_1\vol_1\daily\lccqueue\testdbc.dbc;SourceType=DBC;

I would suggest that you play more with it and try to figure out why it doesn't work for you.
>
>2. Using OPENQUERY() in 3 table join
>You didn't say what the problem is but the following works for me

SELECT * FROM pubs.dbo.authors au
>	JOIN (SELECT * FROM OPENQUERY(testdbc, 'SELECT * FROM test1')) vt
>		ON au.au_id = vt.cc
>