Creating a Linked Server to a MySQL Server in SQL Server
I am writing a Business Intelligence Project and I found I needed to be able to warehouse data from a MySQL Server. Rather than spend tons of money for a DB conversion software kit, I decided to use a linked server to communicate between the two. Luckily, a generous blogger at Windows Live Spaces provided me with all the steps, pretty much. Thanks Dinesh!
Also, please note, he is wrong on a few items. You don't need to use OPENQUERY, at least not for SQL Server 2005. You just need to use the triple-dot notation, AKA
SELECT * FROM LINKEDSERVER...tblname
And I wasn't able to get the generic DSN method working. I created a local SYSTEM DSN first, then just put the system DSN name in the appropriate linked server slot.