title: Do I have to use OpenQuery to query a MySQL Linked Server from SQL Server?
body: <p>I'm querying a MySQL linked server from SQL Server.</p>
  
  <p>I can query the linked server using OpenQuery as in the following example.</p>
  
  <pre><code>SELECT * FROM OPENQUERY(MyLinkedServer, 'SELECT * FROM SomeTable')
  </code></pre>
  
  <p>I have tried querying the linked server using a four-part name as in the following example.</p>
  
  <pre><code>SELECT * FROM MyLinkedServer.MyDatabase.DBO.SomeTable
  </code></pre>
  
  <p>That returns an error stating that "the provider does not expose the necessary interfaces to use a catalog or schema."</p>
  
  <p>Is there any way to query a linked server without using OpenQuery?</p>
  
  <p>Thanks!</p>
  
  <p><em>Update: Per Shredder's answer, the correct syntax is as follows.</em></p>
  
  <pre><code>SELECT * FROM MyLinkedServer...SomeTable
  </code></pre>