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

Any ideas?