i know this is an old post, btw great detailed instructions on how to setup mySQL linked server on MS SQL server. I have a question though, right now i am using
Select field1,field2 from [Linked Server]...
and it retrieves the rows from the table that i specified in the ODBC connection, how would i do it if i want to retrieve data from a different db , i tried leaving the database drop down blank in the ODBC and tried Select field1,field2 from [Linked Server].[db name]..
and i get an error 'A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.'
Any idea how to do this ? thank you in advance.