I am trying to create a linked server object in my 2008 r2 MSSQL Server using an ODBC connection. I have installed the latest 64bit MySQL ODBC driver. Testing this connection everything is fine.
I followed this example: http://www.packtpub.com/article/mysql-linked-server-on-sql-server-2008
But if I press the "ok" button the dialog will try forever to finish the job.
I got a failure message, if I intentionally use the wrong login credentials ins the security tab.
Im a bit lost, can someone please push me into the correct direction?