I've got 2000 and 2005 both. I've tried this on my local server with EM and QA as well as Management Studio.
Same result.
VFPOLEDB works fine - except it won't update.
MS Jet works fine - but also craps out on the update.
I know I could easily write a VFP program - but that's not really the point, is it?
And by the way, thank you for taking the trouble once again.
>What's SQL Server version? I know that it works under SQL 2000. Don't remember if Itried with later versions.
>
>>
>>This is all quite frustrating.
>>
>>I've set up (yet another) linked server.
>>
>>
>>
>>/****** Object: LinkedServer [DBF] Script Date: 01/19/2009 16:46:26 ******/
>>EXEC master.dbo.sp_addlinkedserver @server = N'DBF', @srvproduct=N'VFP', @provider=N'MSDASQL', @datasrc=N'DbfTest'
>>
>>
>>
>>
>>That's the server, but when I query it or click Catalogs -> Refresh it says:
>>
>>
>>OLE DB provider 'UNKNOWN' reported an error. One or more arguments were reported invalid by the provider. (Microsoft SQL Server, Error: 7399)
>>
>>
>>What am I doing wrong?
>>
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)