I have set up a linked server from SQL2000 to a MySQL database. I am able to select data from the linked sever but I am unable to update or delete data from the linked server. I have posted select code that works and delete codes that does NOT, along with the error that occurs.
query code that works:
select * from openquery(BEEF19_MYSQL_DEV, 'select * from stgpackprd')
delete code that does NOT work:
delete from OPENQUERY(BEEF19_MYSQL_DEV, 'SELECT UNIQUE_ID, PLANT_NUM, PRODUCT_CD from stgpackprd')
where UNIQUE_ID = (SELECT UNIQUE_ID FROM Sparoe.dbo.TRANSACTIONS_FOR_PROD_MASTERS WHERE UPDATED_FLAG = '2' )
Server: Msg 7333, Level 16, State 2, Line 1
Could not fetch a row using a bookmark from OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: Multiple-step operation generated errors. Check each status value.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetLocate::GetRowsByBookmark returned 0x80040e21: ].