trying to connect from SSMS for MS SQL 2012 to MySQL 5.521
in order to run a stored procedure to pull data from MySQL and process it in SQL 2012
i believe i need a linked server.
to get a linked server i believe i need an ODBC connection.
i am running windows 7 professional 64 bit
when creating the linked server, not sure what to put into the provider string or location... catalog i am assuming is the database i want to connect tol