Add linked server from SQL-Server to MySQL: "Data source name not found" (Error:7303) I'm trying to link my SQL-Server 2005 on Windows Server 2008 R2 with MySQL 5.5.40 on a different computer. I have followed this guide:

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

However, when i try to test the connection under "Linked Servers" as you can see in this screenshot:



i'm getting this error:



The ODBC data source was added as shown in above link as you can see here:



What can be the reason for this? Note that the Server2008 is a 64bit OS, if that matters.
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.