Add linked server from SQL-Server to MySQL: "Data source name not found" (Error:7303)
The ODBC Connection needs to be a System DSN. The connection is made as the service account, not you, and so the service account doesn't know about your User DSN.

From the article:


  Select the System DSN tab to configure a data source for the entire
  system.