SQL Server builds MySQL connection servers

1. Install MySQL ODBC driver on SQL Server side

2. Add MySQL to an ODBC data source (Control Panel \ All Control Panel items \ Administrative Tools)

To add a configuration driver to a User DSN and System DSN

Note: The character set must correspond to the MySQL server, if MySQL uses the GBK character set, it is necessary to set the character set to GBK, otherwise import into SQL may appear the question mark garbled.

3. Establishing a connection server on the SQL Server side

After filling out may be out of the wrong password, etc., need to fill in the security of the connection required user name and password

Test the connection to succeed.

SQL Server builds MySQL connection servers