I have a linked server that has been running this update for several years. It is on a SQL 2012 and 2012 R2 OS. We took a Microsoft security update this weekend and now this query is failing. I have included the error message. I can go to MYSQL Workbench with the same userid and make the update and the syntac is very similar. I am using MYSQL ODBC 8.0.26 which is the latest. I have install this ODBC driver on my personal PC and get the same results.
ivr Ivr.exported OPENQUERY(MYSQLprd, ) ivr IVR.id
Here is the error:
OLE DB provider "MSDASQL" for linked server "MYSQLprd" returned message "[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.33-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`ivr_request` SET `exported`=? WHERE `id`=? AND `exported` IS NULL' at line 1".
Msg 7343, Level 16, State 4, Line 1