I add the linked server like so:

Declare @server varchar(50),
@srvproduct varchar(50),
@provider varchar(50),
@datasrc varchar(50)

Set @server = 'AccData'
Set @srvproduct = ''
Set @provider = 'MSDASQL'
Set @datasrc = 'AccData'

EXEC master.dbo.sp_addlinkedserver
   @server,  
   @srvproduct,
   @provider,
   @datasrc

* Where AccData is a VFP ODBC datasource (System dsn), that points to a free-table directory

And when I try to query I get

....
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "AccData". (Microsoft SQL Server, Error: 7303)

For help, click...


Of course there is no help to be had from MS and googleing it has not brought me further, so an help is welcome.