Updating Visual FoxPro from SQL Server

Posted by David Stein on Stack Overflow See other posts from Stack Overflow or by David Stein
Published on 2010-04-23T20:41:14Z Indexed on 2010/04/23 20:43 UTC
Read the original article Hit count: 566

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about visual-foxpro