Linked Server Question

[jfield817]

Foxpro tables have been set up as a Linked Server
to a SQL 7.0 database .....I'm pretty sure
the Linked Server part is set up correctly however
getting this errormsg when I use the Openrowset
query and I know the dbf file exists and was referenced
in the sp_addlinkedserver procedure


select * from openquery([LinkedServername], 'select * from filename')

The following appears:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]File 'filename.dbf' does not exist.]

Thanks
John

 

[martynh]

If you open Enterprise Manager, and look at the linked server do you see column details in the file? (You might need to change the Linked Server permissions so that you can access the Linked Server using account you logon to EM with)