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.
Subject
Written By
Posted
September 13, 2021 01:58AM
Re: Linked Server Delete query problem
September 13, 2021 02:48AM
September 13, 2021 11:02AM
September 13, 2021 11:17AM
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.