Hi Marc,

All you have to do is to install VFP OLE DB provder or VFP ODBC driver depending on which one you want to use. Which of two code samples did you ran and what error did you get?


>I tried this code on my SQL Server, but I still get errors. I think my ODBC is not correctly configured... How should I configure it?
>
>Thanks
>
>>>What is the correct syntax for adding a linked server into SQL2000 which is a fox free table directory
>>>
>>>how do you call these 2 extended procs?
>>>sp_addlinkedserver
>>>sp_addlinkedsrvlogin
>>>
>>>tia
>>
>>

-- Using OLEDB provider for VFP
>>sp_addlinkedserver @server = 'test',
>>	@srvproduct = 'VFP',
>>	@provider = 'VFPOLEDB.1',
>>	@datasrc = 'H:\Temp',
>>	@provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'
>>-- Using OLEDB provider for ODBC
>>sp_addlinkedserver @server = 'test1',
>>	@srvproduct = 'VFP-ODBC',
>>	@provider = 'MSDASQL',
>>	@provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=;
>>		Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No;
>>		Exclusive=No; SourceType=DBF;SourceDB=h:\Temp'
>>

Be advised that in my tests the linked server to VFP free tables that uses OLEDB provider for ODBC was considerably faster.