Through the link to the MYSQL server, according to the online tutorials, finally can only query, can't delete

CodePudding user response:

Please stick the complete error message..

CodePudding user response:

When the update error
Link server "MYSQLTY" OLE DB access interface "MSDASQL" returned message "[MySQL] [ODBC 8.0 (w) Driver] [mysqld 5.6.14 - log] always execute the statement: impossible to write to the binary log since BINLOG_FORMAT=statement and at further one table USES a storage engine limited to row - -based logging. The InnoDB is limited to the row - logging the when the transaction isolation level is the READ COMMITTED or READ UNCOMMITTED.",
Message 7343, level 16, state 4, line 2
Link server "MYSQLTY" OLE DB access interface "MSDASQL" unable to UPDATE tables "[MSDASQL],"

CodePudding user response:

Insert the wrong

Message 7399, level 16, state 1, line 2
Link to the server "MYSQLTY" OLE DB access interface "MSDASQL" error, the provider did not give any information about the error,
Message 7343, level 16, state 2, line 2
Link server "MYSQLTY" OLE DB access interface "MSDASQL" can't INSERT INTO table "[MSDASQL]," the unknown provider error,

CodePudding user response:

Delete the error


Link server "MYSQLTY" OLE DB access interface MSDASQL returned to the message of "[MySQL] [ODBC 8.0 (w) Driver] [mysqld 5.6.14 - 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 '=' 627 ' 'test at line 1, "
Message 7350, level 16, state 2, line 2
Can't from the link server "MYSQLTY" OLE DB access interface "MSDASQL" column information,

CodePudding user response:

Solved, encounter problems with you