14

cannot create linked server with ms sql2008 and mysql

view full story
linux-howto

http://serverfault.com – 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? (HowTos)