How to create a MySQL linked server on MS SQL Server

System environment:

Microsoft Windows Server 2003 Enterprise Edition Service Pack 2

[Microsoft Windows NT-5.2 (3790)]

SQL Server Enterprise Edition 8.00.2066 (SP4)

Centos

Mysql

Deployment steps:

Linux Environment

1. Create an account in MySQL and Access database permissions (including allowed access IP)

Windows environment

1. Create a local account in MSSQL, preferably with the same account created in MySQL.

2. Installation

Vcredist_x86.exe

Mysql-connector-odbc-5.3.4-win32.msi

3. Configure Data Source ODBC

Start-up--Control panel--Administration tools--Data Source (ODBC)-->ODBC data Source Manager-System dsn--> Add-on (MySQL ODBC 5.3 ANSI Driver)--Complete

The following dialog box pops up

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/3E/wKiom1Ve18iRR9MDAAGZZJtt2d4670.jpg "title=" MySQL Connector.png "alt=" Wkiom1ve18irr9mdaagzzjtt2d4670.jpg "/>

Fill in the configuration information, click (OK)

4. Configure the connection server

Start-Up Program-->microsoft SQL Server--> Enterprise Manager--expand Microsoft SQL server-->sql Server Group-->local--> Security-- > (right-click) Link server--new linked server

General tab page

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/3E/wKiom1Ve3YzCOwGzAAHTsZDu7L4436.jpg "style=" float: None; properties of the "title=" linked server-general. png "alt=" wkiom1ve3yzcowgzaahtszdu7l4436.jpg "/>

Security tab page

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/3A/wKioL1Ve3waA726VAAGM8tshtmc969.jpg "style=" float: None; properties of the "title=" linked server-security. png "alt=" wkiol1ve3waa726vaagm8tshtmc969.jpg "/>

The other options are the default values. Click (OK) and the link server creation is complete.

This article from the "Learning" blog, reproduced please contact the author!

How to create a MySQL linked server on MS SQL Server