Good morning, the issue is like this, I have two databases sql server and mysql, every time an insert is made (this side of sql server) in a table, these changes must also affect the table in mysql , I have a linked server, I decided to make a trigger to insert them in mysql but I have the following error:
OLE DB provider "MSDASQL" for linked server "likedservername" returned message "[MySQL] [ODBC 8.0 (a) Driver] Optional feature not supported" .Msg 7391, Level 16, State 2, Procedure triggername, Line 4 [ Batch Start Line 0] The operation could not be performed because OLE DB provider "MSDASQL" for linked server "linkedservername" was unable to begin a distributed transaction.
I make the connection between servers by means of an obdc, when inserting these same data without executing the instruction inside the trigger it does, but it is not automatic.
someone who can help me would be grateful, and consulted in other pages and mention that mysql is not compatible with these transactions.