SQL Server version 2008r21. Download the latest MySQL ODBC driver from MySQL website: http://www.mysql.com/downloads/connector/odbc/, the version I downloaded is 5.3 Whether it is 32-bit or 64-bit, the first down, Standby 2, the installation of the driver. 3. Start configuring the data source new linked server Some of these: 1, server type Select other data source 2, product name: Here can be filled, in order to good logo I filled a mysql3, data source, location, directory here all do not have to fill in 4, Access interface string This is sample Driver={my SQL ODBC 5.3 Unicode Driver}; Server= ' Server path '; user= ' MySQL login user name '; password= ' mysql login password '; option=3 the name of the MySQL ODBC 5.3 Unicode Driver, which is the same name as the ODBC data Source manager. 5. I only installed the 64-bit version at the beginning. If there is an error in configuration. Initialization failure and so on, you can install the 32-bit version open C:\Windows\SysWOW64\odbcad32.exe here to configure the test. (In fact, I do not know the specific reasons, I would like to have a man pointing out) good ~. Just test it, you can.
SQL Server link MySQL operation steps