The account SQL Server runs under has to have access rights to the dirrectory with VFP tables.

>I want to access VFP data from SQL-Server.
>
>1)
>declare @x int
> EXEC @x = sp_addlinkedserver
> @server = 'Test',
> @srvproduct = '',
> @provider = 'VFPOLEDB.1',
> @datasrc = '\\mainserver\poy\Fox_2002\boNotify\Data'
>print @x
>Return 0
>
>2) select * from sys.servers where name = 'Test'
>Returns the row
>
>3) SELECT *
>FROM OPENQUERY(Test, 'SELECT * from company')
>Get error:
>Msg 7399, Level 16, State 1, Line 1
>The OLE DB provider "VFPOLEDB.1" for linked server "Test" reported an error. Access denied.
>Msg 7350, Level 16, State 2, Line 1
>Cannot get the column information from OLE DB provider "VFPOLEDB.1" for linked server "Test"
>
>4) I think I need to do a linked server login so I do:
>declare @a int
>EXEC @a = sp_addlinkedsrvlogin 'mark'
>print @a
>Returns 0
>
>I get the same error message.
>
>We use windows authentication for SQL Server