MySQL Forums
Forum List  »  Newbie

Re: Linked Server Delete query problem
Posted by: alper tutku
Date: September 13, 2021 02:48AM

Edit, I changed table and query for testing and resault:

Query:
INSERT OPENQUERY (TT, 'SELECT alan FROM nutest.testtablo')
VALUES ('NewTitle');


DELETE OPENQUERY (TT, 'SELECT alan FROM nutest.testtablo where alan=''NewTitle''');


Resault:

1 row(s) affected)

OLE DB provider "MSDASQL" for linked server "TT" returned message "[MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.3.9-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '..`testtablo` WHERE `alan`=?' at line 1".
Msg 7345, Level 16, State 1, Line 6
The OLE DB provider "MSDASQL" for linked server "TT" could not delete from table "SELECT alan FROM nutest.testtablo where alan='NewTitle'". There was a recoverable, provider-specific error, such as an RPC failure.

Options: ReplyQuote


Subject
Written By
Posted
September 13, 2021 01:58AM
Re: Linked Server Delete query problem
September 13, 2021 02:48AM


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.