<div>
Thanks sammy,<br />
<br />
I tried that but still got the same error, then I tried running the statemen in SQLyog and got the same error, so......the trick was in the character used for quoting<br />
<br />
It needs be an ` (a sort of backwards apostrophe) and not a normal ' (apostrophe) <br />
<br />
thanks<br />

</div>


Thanks sammy,

I tried that but still got the same error, then I tried running the statemen in SQLyog and got the same error, so......the trick was in the character used for quoting

It needs be an ` (a sort of backwards apostrophe) and not a normal ' (apostrophe)

thanks


<div>
yes, that's what I had in mind. I just didn't come up with the correct name which is back-ticks.<br />
<br />
Thanks for the points and grade.
</div>


yes, that's what I had in mind. I just didn't come up with the correct name which is back-ticks.

Thanks for the points and grade.

<div>
<div class="content wysiwyg-content">
I am using SQL Server 2008 and I have a linked server to a MySQL database (linked_db)<br />
<br />
When I execute the following statement I get data returned without a problem:<br />

<pre><code id="code-10-26513868-1">execute ('select * from agentactivity') at linked_db</code></pre>
<br />
However, when I execute this one:<br />

<pre><code id="code-10-26513868-2">execute ('select * from call') at linked_db</code></pre>
<br />
I get the error:<br />
<br />
OLE DB provider &quot;MSDASQL&quot; for linked server &quot;shoretel&quot; returned message &quot;[MySQL][ODBC 5.1 Driver][mysqld-5.0.52-ente<wbr />rprise-nt]<wbr />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&quot;.<br />
<br />
Any idea's?
</div>
</div>


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:
(CODE)

However, when I execute this one:
(CODE)

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?

TRying to query MySQl from SQl Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.