This was very helpful.
A rider question ( 2 in fact ) is why this odbc connection will not work in 2 scenarios ?
1. If I use openrowset , i am able to query a table or view but not if i script our select form the table in SSMS. Says you do not have permission. Linked server exists without issues and able to test connection ok in control panel ( ODBC conn manager applet ).
2. In SSRS 2012 , create a datasource and test the connection , it fails saying no default source specified. Where does one set this ?
-----------------
Note :The DEV who granted access to the MySQL Database set a user id with blank password . Could this be causing issues ?
Anyway , thanks for the post. It was helpful.