MySQL Forums
Forum List  »  Connector/ODBC

Re: Unable to update linked MySQL table from SQL Server with MySQL Connector/ODBC 8.0
Posted by: Ernst Höfler
Date: October 12, 2021 03:55AM

After a very long time with try and error I could find the solution 😊

Instead of using QPENQUERY it's necessary to use EXEC AT syntax as follows:

For selecting data
EXEC('SELECT * FROM admin_db.test_odbc_3 WHERE TDBC_ID = 3') AT TDBAMYSQLTEST
works fine.

And for updating data
EXEC('UPDATE admin_db.test_odbc_3 set TDBC_DESC = ''mynew_value'' WHERE TDBC_ID = 3') AT TDBAMYSQLTEST
works fine as well!

Options: ReplyQuote


Subject
Written By
Posted
Re: Unable to update linked MySQL table from SQL Server with MySQL Connector/ODBC 8.0
October 12, 2021 03:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.