Linking MySQL and SQL Server using Linked Server

Googling for using Linked Server functionality in SQL server to link a MySQL database returns lots of results. However, reaching a final answer may take 5 or 6 hours of cursing. Below, I am describing my adventure hope saving you some curse: 1) Install “MySQL ODBC 5.1 Driver” Connector for ODBC [here] 2) Go to ODBC Data Source Administrator (Control Panel/Administrative Tools/Data Sources (ODBC)) 3) Add a new System DSN:...

December 10, 2011 · 2 min · Amir Mohtasebi