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?
>>