troubleshooting Question

TRying to query MySQl from SQl Server

Avatar of BrianFord
BrianFordFlag for United States of America asked on
MySQL ServerMicrosoft SQL Server 2008
3 Comments1 Solution419 ViewsLast Modified:
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-enterprise-nt]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".

Any idea's?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros