title: Linked servers - SQL2008 to MySql - error: 7303 - Data source
body: <p><strong>Problem:</strong></p>
  
  <p>I use <code>SQL Server 2008</code>.</p>
  
  <p>We have here a linked server, linking to a MySql Database.</p>
  
  <p>But since today, when I click "test connection", it shows me this error:</p>
  
  <p>( I can't post images yet):</p>
  
  <pre><code>The test connection to the linked server failed.
  
  
  Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MANTIS".
  
  OLE DB provider "MSDASQL" for linked server "MANTIS" returned message "[Microsoft][ODBC Driver  
  Manager] Data source name not found and no default driver specified". (Microsoft SQL Server,  
  Error: 7303)
  </code></pre>
  
  <p>What should I do? </p>
  
  <p>It was working yesterday. I thought about "data sources ( ODBC)". Yes, There is no DataSources for MySql ( it doesn't even show me the option to add a <code>mySql odbc</code> when I click <code>ADD</code>), but it was working yesterday !!</p>
  
  <p>I didn't find a reasonable solution from any post.</p>