如何在SQL Server Management Studio中创建和配置链接服务器以连接到MySQL

This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.

本文将指导您完成在SSMS中成功创建链接服务器以连接到MySQL数据库的所有必要步骤。

This article is divided in three sections:

本文分为三个部分：

• ODBC driver for MySQL ODBC驱动程序
• Configure ODBC driver to connect to MySQL database
  配置ODBC驱动程序以连接到MySQL数据库
• Create and configure a Linked Server using ODBC driver
  使用ODBC驱动程序创建和配置链接服务器

为MySQL安装ODBC驱动程序 (Installing ODBC driver for MySQL)

ODBC stands for Open Database Connectivity (Connector). It’s developed by Microsoft in the 1990s. Generally, that is API (Application Programming Interface) for accessing database systems.

ODBC代表开放式数据库连接（连接器）。 它由Microsoft在1990年代开发。 通常，这是用于访问数据库系统的API（应用程序编程接口）。

For non-Windows OS, JDBC (Java Database Connectivity) is used.

对于非Windows操作系统，使用JDBC （Java数据库连接）。

Before installing the ODBC driver for MySQL on Windows, make sure that Microsoft Data Access Components (MDAC) are up to date and the Microsoft Visual C++ 2013 Redistributable Package is installed on your system.

在Windows上为MySQL安装ODBC驱动程序之前，请确保Microsoft数据访问组件（MDAC）是最新的，并且系统上已安装Microsoft Visual C ++ 2013可再发行组件包 。

Under this link, the MySQL ODBC drivers for Windows can be downloaded and installed. There are two versions of MySQL ODBC drivers for Windows that can be installed, depending on which application will be used with:

在此链接下 ，可以下载和安装WindowsMySQL ODBC驱动程序。 可以安装两个版本的Windows版MySQL ODBC驱动程序，具体取决于将与哪个应用程序一起使用：

• mysql-connector-odbc-8.0.17-win32.msi for 32-bit application
  用于32位应用程序的mysql-connector-odbc-8.0.17-win32.msi
• mysql-connector-odbc-8.0.17-winx64.msi for 64-bit application
  用于64位应用程序的mysql-connector-odbc-8.0.17-winx64.msi

Installation of MySQL ODBC driver for Windows is straightforward. Double-click on the downloaded file, the Welcome dialog will appear:

WindowsMySQL ODBC驱动程序的安装非常简单。 双击下载的文件，将出现“ 欢迎”对话框：

After pressing the Next button, the License Agreement dialog appears. If you agree with the license agreement, press the I accept the terms in the license agreement radio button and click the Next button:

按“ 下一步”按钮后，将出现“ 许可协议”对话框。 如果您同意许可协议，请按“ 我接受许可协议中的条款”单选按钮，然后单击“ 下一步”按钮：

Under the Setup Type dialog, choose the Typical radio button and press the Next