Shulou(Shulou.com)05/31 Report--

SQL Serve how to link remote MySQL, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

1. Install the MYSQL ODBC driver on the SQL SERVER server

2. After installation, go to Management tools-ODBC data sources-add system DSN--Select MYSQL ODBC 3.51 DRIVER- to complete.

MYSQL connection parameters will pop up.

Data Source Name: data source name

Decription: describe, write whatever you want

IP of the Server:MYSQL server

The port of Port:MYSQL, the default is 3306. It can be changed.

User: connect the account (the account authorized on mysql and give the appropriate permissions)

Password: password

Database: select linked database

After filling it out, click test. If it is successful, it will jump out of the prompt box as shown in the picture.

After success:

3. Open the SQL database and find the linked server. Everyone will create a linked server, so I'll send the parameters. As shown in the picture, there is no need to fill in the rest of the general options. Just be sure.

Here, it is important to note that the access interface should select "Microsoft OLE DB Provider for ODBC Drivers".

Data source: select the previously created ODBC interface.

4. Test:

(query statement)

Double-click the code to select all 1SELECT * FROM OPENQUERY (MYSQL, 'select * from table')

(insert statement)

Double-click the code to select all 1Insert openquery (MYSQL, 'select * from table') (id,name,password) values (8' Zidane', '99999') after reading the above, have you mastered the method of how to link remote MySQL in SQL Serve? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.