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


C:\vfptest is a directory on the server that has the .dbf files I'm
trying to access.

When I use sp_tables_ex, I get output similar to the following:

TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE
c:\vfptest NULL country TABLE
c:\vfptest NULL orders TABLE
c:\vfptest NULL customer TABLE


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?

Thanks.