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:
update util...utcomp
set fmaddress = '123 Elvis Dr.'
where fcsqldb = 'M2MDATA01'
I receive the error:
OLE DB provider "VFPOLEDB" for linked server "util" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 7333, Level 16, State 2, Line 2
Cannot fetch a row using a bookmark from OLE DB provider "VFPOLEDB" for linked server "util".
I have the latest version (9.0) installed so I should have the latest provider. Am I doing something wrong? Is it not possible to update VFP from SQL?
