>>>Richard,
>>>
>>>>>I've created a linked server on SQL7 with the following commands:
>>>
>>>>>EXEC sp_addlinkedserver
>>>>>@server = 'DBFSERVER' ,
>>>>>@provider = 'MSDASQL',
>>>>>@provstr = 'DRIVER=Microsoft FoxPro VFP
>>>>>Driver(*.dbf);UID=;Deleted=Yes;Null=Yes;Collate=Machine
>>>>>;BackgroundFetch=Yes
>>>>>;Exclusive=No
>>>>>;SourceType=DBF
>>>>>;SourceDB=c:\vfptest',
>>>>>@srvproduct='s'
>>>>>go
>>>
>>>>>But I cannot query these tables. No syntax seems to work. I've tried
>>>
>>>>>select * from [dbfserver].[c:\vfptest]..[orders.dbf]
>>>>>select * from [dbfserver]...[orders.dbf]
>>>>>select * from [dbfserver]...[orders]
>>>>>select * from [dbfserver].[c:\vfptest].dbo.[orders.dbf]
>>>>>select * from [dbfserver].[c:\vfptest].dbo.[orders]
>>>
>>>>>But all these return errors either that the file could not be found or
>>>>>that the schema or catalog supplied are invalid. Does anyone have any
>>>>>ideas?
>>>
>>>Solution is as follows:
>>>
>>>sp_addlinkedserver
>>>'DBFSERVER','', 'MSDASQL', NULL, NULL, 'Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=c:\vfptest\;SourceType=DBF;
>>>Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;'
>>>
>>>
>>>With VFP Queries you cannot use the four part syntax (i.e. servername.database.owner.table). You have to use the openquery command
>>>This wil then allow queries such as :
>>>
>>>SELECT * FROM OPENQUERY([DBFSERVER],'SELECT * FROM Orders')
>>>
>>>NOTE: SELECT * FROM [DBFSERVER]...Orders WILL NOT WORK
>>>
>>>If you're working with a dbc, the above syntax is the same, you just need to change the connection string to be the dbc name in the sourcedb and the sourcetype to dbc.
>>>
>>>Joins can then be performed between SQL tables and Fox as follows:
>>>
>>>[Assuming there is a field called order_id in both your VFP table and the SQL server table]
>>>
>>>select sql7table.*, vfpdbf.* from
>>>OPENQUERY([DBFSERVER],
>>>'SELECT * from orders where order_id = 200 (for example)) as vfpdbf
>>>join sql7server.database.owner.sql7table as sql7table on vfpdbf.order_)id = sql7table.order_id
>>>
>>>It looks a bit long winded I know, but I spent about a week on this, and this is the best way I could find.
>>>
>>>Let me know if this helps, or if you find a better way.
>>>
>>>Cheers
>>>Steve Lea
>>
>>I am trying to do this, but after creating the Linked Server, it shows no tables in the Enterprise Manager and when I try to run my query it gives me an ODBC error stating that the table was not found.
>
>Have you tried calling the VFP function SQLTABLES()? It's a quick way to confirm your connection...
>
>- Bruce Allen

The SQLTABLES function returns tables in the default database associated with the ODBC data source. Is it possible to have a Linked Server as the default database?