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:
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.