Connect ODBC to access MySql

Environment: windows2008 + sqlserver2008 A installation mysql-connector-odbc-5.2.5-winx64.msi must be installed 5.2.5, install the mysql-connector-odbc-5.3.4-winx64 will report Error 2 configuration ODBC after installation in the control panel-management tools-data source (ODBC) -> System DNS-> Add. You must select ANSIDriver. Otherwise

Environment: windows 2008 + sqlserver 2008 one installation mysql-connector-odbc-5.2.5-winx64.msi must be installed 5.2.5, installation mysql-connector-odbc-5.3.4-winx64 will report Error 2 configuration ODBC after installation in Control Panel-administration tools-Data Source (ODBC) -> System DNS-> Add. You must select ANSIDriver. Otherwise

Environment: windows 2008 + sqlserver 2008

One install mysql-connector-odbc-5.2.5-winx64.msi

5.2.5 must be installed, and an error is reported when the mysql-connector-odbc-5.3.4-winx64 is installed

Ii. Configure ODBC

After installation, choose Control Panel> Administrative Tools> data source (ODBC)> System DNS>. You must select the ANSI Driver. Otherwise, Chinese characters are garbled.

Create a linked server in Sqlserver

4. Test the linked server performance

Select * from openquery (MYSQL213, 'select * from Mysql table ')