I am using SQL Server 2008 and I have a linked server to a MySQL database (linked_db)
When I execute the following statement I get data returned without a problem:
execute ('select * from agentactivity') at linked_db
However, when I execute this one:
execute ('select * from call') at linked_db
I get the error:
OLE DB provider "MSDASQL" for linked server "shoretel" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.0.52-ente
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 'call' at line 1".