>Has anyone ever created a SQL Server 2000 linked server to a Visual FoxPro Database?
>I have tried using the vfpoledb and cannot seem to get it to work.
>Any help would be greatly appriciated.

Hi Theo,

-- Create VFP OLE DB linked server to DBC
sp_dropserver @server = 'VFPoledbDBC'
GO
-- Using OLEDB provider for VFP
sp_addlinkedserver @server = 'VFPoledbDBC', 
	@srvproduct = 'VFP',
	@provider = 'VFPOLEDB.1', 
	@datasrc = 'H:\Program Files\microsoft visual foxpro 8\Samples\Data\testdata.dbc', 
	@provstr = 'Collating Sequence=MACHINE'
GO
-- Perform query
SELECT * FROM VFPoledbDBC...customer
-----------
-- Create VFP OLE DB linked server to Dbf's (free tables)
sp_dropserver @server = 'VFPoledbDbf'
GO
-- Using OLEDB provider for VFP
sp_addlinkedserver @server = 'VFPoledbDbf', 
	@srvproduct = 'VFP',
	@provider = 'VFPOLEDB.1', 
	@datasrc = 'H:\Program Files\microsoft visual foxpro 8\Samples\Data', 
	@provstr = 'Collating Sequence=MACHINE'
GO
-- Perform query
SELECT * FROM VFPoledbDbf...customer

See also
- Re: SQL linked server with oledb Thread #633116 Message #633186
- Re: Linked server with the database on VFP Thread #700708 Message #727555