SQL Server links to the MySQL database

SQL Server links to the MySQL database

How to link: Link via OLE DB interface

Link tool: In the local "Administrative Tools" SELECT "ODBC Item" here to create the MySQL database chain.

MySQL settings:

Create a user for SQL Server to use

Requirement: This user has permission to access MySQL specified database

SQL Server settings: Create a dblink step to formally create a MySQL library in a SQL Server database:

1. Select "Linked server" under "Server Objects" right-click the mouse and select "New linked server" step-by-step configuration:

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/74/CD/wKioL1Yp0WOiDVIcAAI3A7ztYmY866.jpg "title=" Ssdblink.png "alt=" Wkiol1yp0woidvicaai3a7ztymy866.jpg "/>
   

2. After creation, test for a normal connection with the following SQL statement:

   Select *from openquery (mysql888, ' select * from Mysql.user ')

If the connection can be successful. If you cannot connect, then check whether ODBC or SQL Server Dblink is configured correctly.

This article from "10675043" blog, declined reprint!

SQL Server links to the MySQL database