update openrowset ('vfpoledb.1','\\pjkserver\data\apps\app1\data';'';'','Select active from mytable where pkref = "E10295"') Set active = 0I receive the error
Server: Msg 7301, Level 16, State 2, Line 1 Could not obtain a required interface from OLE DB provider 'vfpoledb.1'. OLE DB error trace [OLE/DB Provider 'vfpoledb.1' IRowsetChange::QueryInterface returned 0x80004002: IRowsetChange].If I just execute the Select part it works fine - I have the latest VFPOleDB driver and am running XP pro Service Pack 2, any ideas ?