I'm having problems accessing mySQL data from SQL 2008 database.
I created a linked server through ODBC DSN.
When I expand mySQL linked server node in SQL Management studio I can see the list of all tables in mySQL db. But I cannot access the data - when I right click on a table and try to script it I get
" [LINKED_MYSQL].[db]..[tbl] contains no columns that can be selected or the current user does not have permissions on that object."
When I try "SELECT * FROM [LINKED_MYSQL].[db]..[tbl]"
I get the following error -
"Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "LINKED_MYSQL". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema."