title: SELECT * FROM Linked MySQL server
body: <p>I have a SQL Server 2012.(120.120.55.15)</p>
  
  <p>Today I linked MySQL server(120.120.55.30) to my SQLServer and gave it a name <strong>"MYSQL".</strong>  </p>
  
  <p>In Object Explorer everything seems fine. I can see <strong>MySQL</strong> server's database "<strong>exampleDataBase</strong>" and tables in it. </p>
  
  <p>But when I try to run select query like this:</p>
  
  <pre><code>SELECT * 
  FROM   openquery
          (
          MYSQL, 
          '
           SELECT * 
           FROM [exampleDataBase].[msProcMatrix]
          '
          )
  </code></pre>
  
  <p>I get a mistake:</p>
  
  <blockquote>
    <p>Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for
    linked server "MYSQL" reported an error. The provider did not give any
    information about the error. Msg 7350, Level 16, State 2, Line 1
    Cannot get the column information from OLE DB provider "MSDASQL" for
    linked server "MYSQL".</p>
  </blockquote>
  
  <p>What should be additionally done to use my linked MySQL server?</p>