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

This article shows you how to link to a remote MySQL database in SQLServer. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

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

Http://dev.mysql.com/downloads/mirror.php?id=376346( address)

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: selecting linked

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)

SELECT * FROM OPENQUERY (MYSQL, select * from table)

(insert statement)

Insert openquery (MYSQL, select * from table) (id,name,password) values (8, Zidane, 99999)

The above is how to link to a remote MySQL database in SQLServer. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.