Updating Visual FoxPro from SQL Server
- by David Stein
I'm trying to update some simple Visual FoxPro tables with SQL Server. I've created a linked server with the following:
sp_addlinkedserver @server = 'UTIL',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB',
@datasrc = 'L:\M2MDATA\Util\util.dbc'
GO
And the following works:
select * from UTIL...utcomp
However, I cannot use the following statement:…