Sql-server – Add linked server from SQL-Server to MySQL: “Data source name not found” (Error:7303)

MySQLmysql-5.5sql serversql-server-2005windows-server

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:

enter image description here

i'm getting this error:

enter image description here

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

enter image description here

What can be the reason for this? Note that the Server2008 is a 64bit OS, if that matters.

Best Answer

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.

Related Question