Could not fetch a row using a bookmark from OLE DB provider 'VFPOLEDB'.

I'm trying to update a VFP table via a linked server in SQL 2000, I'm able to use "openquery" to view the records from the table, but when I try the following command:

Update M2MEDI...x830rels

Set favailship = 100

I get the following error

[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]

OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IRowsetLocate::GetRowsByBookmark returned 0x80040e21: 01000000].

Msg 7333, Level 16, State 2, Line 1

Could not fetch a row using a bookmark from OLE DB provider 'VFPOLEDB'.

How do I fix this

Thanks

David Davis

For the linked tables use the four-part naming and make sure that the 'Distributed Transaction Coordinator' service is running on your server.

HTH

|||

Isn't this

M2MEDI...x830rels

the 4 part naming convention

David Davis

|||Looks like you have three dots, not two