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.