Erro getting query from linked server

Asked Mar 07 '23 at 18:17

Active Mar 07 '23 at 18:18

Viewed 10 times

Hello I am trying to get a query in sql from linked server in Mysql but I am getting an error that I do not know. Query:

SELECT * FROM OPENQUERY ([ATP_PROD],
      'SELECT id FROM ta-transactions.transactions_status')

I got this error:

OLE DB provider "MSDASQL" for linked server "ATP_PROD" returned message "[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.38]

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 '-transactions.transactions_status' at line 2". Msg 7321, Level 16, State 2, Line 5

Anyone knows how to solve this?

edited Mar 07 '23 at 18:18

asked Mar 07 '23 at 18:17

Ricardo Ferreira

You need backticks around the database name if it contains special characters like `-`. – Barmar Mar 07 '23 at 18:20
1

```'SELECT id FROM `ta-transactions`.transactions_status'``` – Barmar Mar 07 '23 at 18:21

Erro getting query from linked server

0 Answers0