Good Morning Everyone
I am attempting to create a process to update data on a MySQL Linked Server.
So far I have set up a synonym to the Linked Server/Schema/Table
I can select data from the synonym
When attempting the update I get the following error message
UPDATE dbo.[SYNONYM NAME] SET job_agreement_id=@new_job_agreement_id, bms_job_agreement_id=@new_bms_job_agreement_id WHERE job_agreement_id=@old_job_agreement_id
(2 rows affected)
(3 rows affected)
(100 rows affected)
OLE DB provider "MSDASQL" for linked server "SRV-ORCHID" returned message "Data provider or other service returned an E_FAIL status.".
Msg 7330, Level 16, State 2, Line 36
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "SRV-ORCHID".
Completion time: 2021-04-27T11:29:33.2200247+01:00