How to create a linked server is Microsoft SQL Server to a MYSQL database.

1.  Download mysql odbc driver

2.  Create odbc connection

3.  Change MSDASQL provider in linked servers providers to have:

* nested queries

* level zero only

* allow inprocess

* supports like operator

4.  Create linked server

*  catalog is your database name

*  Product name is "MySQL"

*  Data source:  matches your odbc name

5.  Query logic is "select * from linkedserver...table   

REMEBER:  table names are case sensive