odbc驱动程序配置失败_如何使用ODBC驱动程序配置链接服务器

odbc驱动程序配置失败

Microsoft Open Database Connectivity (ODBC) is an application programming interface (API) designed to access data from a different of database management systems (DBMS). ODBC is designed for relational data stores.

Microsoft开放数据库连接（ ODBC ）是一种应用程序编程接口（ API ），旨在访问来自不同数据库管理系统（ DBMS ）的数据。 ODBC专为关系数据存储而设计。

In this article, we will explain how to install the appropriate ODBC drivers for SQL Server, how to configure ODBC to connect to a SQL Server instance and how to create and configure a Linked Server using the ODBC driver and the MSDASQL provider to query tables on a SQL Server instance.

在本文中，我们将解释如何为SQL Server安装适当的ODBC驱动程序，如何配置ODBC以连接到SQL Server实例，以及如何使用ODBC驱动程序和MSDASQL提供程序来创建和配置链接服务器来查询表。 SQL Server实例。

The diagram below explains the flow of connecting to a SQL Server database using the MSDASQL provider and a SQL Server ODBC driver.

下图说明了使用MSDASQL提供程序和SQL Server ODBC驱动程序连接到SQL Server数据库的流程。

MSDASQL allows OLE DB consumer applications to use ODBC drivers to connect to a data source. The provider transforms incoming OLE DB calls into ODBC calls, and transfers them on to the specified ODBC driver. After that, it retrieves results from the ODBC driver and formats those into OLE DB specific structures which the consumer has access to them.

MSDASQL允许OLE DB使用者应用程序使用ODBC驱动程序来连接到数据源。 提供程序将传入的OLE DB调用转换为ODBC调用，并将其转移到指定的ODBC驱动程序上。 此后，它将从ODBC驱动程序中检索结果，并将结果格式化为用户可以访问的OLE DB特定结构。

为SQL Server安装和配置Microsoft ODBC驱动程序 (Installing and configuring the Microsoft ODBC drivers for SQL Server)

From this link, the Microsoft ODBC drivers for SQL Server can be downloaded and installed. Depending on which Windows operating system version (32-bit or 64-bit) is used, there are two versions of the Microsoft ODBC drivers for SQL Server that can be installed:

通过此链接 ，可以下载和安装SQL Server的Microsoft ODBC驱动程序。 根据所使用的Windows操作系统版本（32位或64位），可以为SQL Server安装两个版本的Microsoft ODBC驱动程序：

• x64\msodbcsql.msi is for the Windows 64-bit version
  x64 \ msodbcsql.msi适用于Windows 64位版本
• x86\msodbcsql.msi is for the Windows 32-bit version
  x86 \ msodbcsql.msi适用于Windows 32位版本

In case that the wrong version of the Microsoft ODBC drivers for SQL Server is trying to be installed (e.g. x86\msodbcsql.msi on the Windows 64-bit version), the following warning message will appear:

如果尝试安装错误版本SQL Server的Microsoft ODBC驱动程序（例如Windows 64位版本上的x86 \ msodbcsql.msi），则会出现以下警告消息：

Let’s install the appropriate Microsoft ODBC drivers for SQL Server. The process of installation of the Microsoft ODBC drivers for SQL Server is very simple and straightforward. Double click on the (e.g. msodbcsql.msi ) file and the welcome screen will appear:

让我们为SQL Server安装适当的Microsoft ODBC驱动程序。 用于SQL Server的Microsoft ODBC驱动程序的安装过程非常简单明了。 双击（例如msodbcsql.msi）文件，将出现欢迎屏幕：

Click the Next button to proceed with installation. Under the License Agreement window read the license terms and if you agree, check the “I accept the terms in the license agreement” radio button and click the Next button:

单击下一步按钮继续安装。 在“ 许可协议”窗口下，阅读许可条款，如果同意，请选中“ 我接受许可协议中的条款 ”单选按钮，然后单击“ 下一步”按钮：

On the Feature Selection window, select the Client Components item and click the Next button:

在“ 功能选择”窗口上，选择“ 客户端组件”项，然后单击“ 下一步”按钮：

Click the Install button on the Ready to Install the Program window to begin the installation of the Microsoft ODBC drivers for SQL Server:

单击“ 准备安装程序”窗口上的“ 安装”按钮，开始为SQL Server安装Microsoft ODBC驱动程序：

In a few seconds, the installation of the Microsoft ODBC drivers for SQL Server finishes. Click the Finish button to close the Microsoft ODBC drivers for SQL Server Setup window:

几秒钟后，用于SQL Server的Microsoft ODBC驱动程序的安装完成。 单击完成按钮以关闭“ SQL Server安装程序”的Microsoft ODBC驱动程序窗口：

To confirm that the Microsoft ODBC drivers for SQL Server is installed, go to Control Panel and under the Program and Features find the Microsoft ODBC drivers for