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