[1] environment
(1) the SQL server2016 SP2
(2) Windows server 2012 R2
(3) odbc8.0.22 version, version mysql5.7.26



As can be seen from the above chart, I related to SQL server server MSDTC service have launch configuration (not post service here, but MSDTC related services have been running);

Question: see the last picture
(1) I used alone insert into openquery (... ), can be inserted in the SQL server data links to mysql server;
(2) once I use transactions, are not, bosses, and where to set? You need to set up or is mysql?

CodePudding user response:

Mysql 5. X to support XA transactions, DTC has also enabled the XA transaction a try,

CodePudding user response:

refer to the second floor schrodinger's DBA response:

mysql 5. X to support XA transactions, DTC has also enabled the XA transaction a try,

Hook up to the XA and mysql also opened innodb_support_xa, useless

CodePudding user response:

 
The exec sp_serveroption 'mysql', 'remote proc transaction promotion', 'false'