I have been trying to create a linked server from SQL7.0 which links to a directory containing Visual Foxpro Tables (using Microsoft Visual Foxpro Driver).

When I expand the linked server I created and look at the tables sub-level, it contains the tables I am expecting to see.

However when I then try to do a select statement I get an error.

The linked server is attached using a Microsoft OLE DB for ODBC Driver with the following connection string:

Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=\\jf_lon_srv00\genesis\foxpro2\data\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;

The SQL Select's I have attemted are as follows:

SELECT * FROM VFPTables.rfrefrsh
rfrefrsh is a table which displays in the tables view on this linked server)

This returns invalid object name

Also SELECT * FROM VFPTables...rfrefresh returns Invalid schema or catalog specified for provider 'MSDASQL'.

Does anyone know of a solution to this?

Cheers
Stephen Lea