ODBC驱动程序的驱动程序之间的差异 [英] Differences Between Drivers for ODBC Drivers

问题描述

我正在使用Windows 10 64位专业版在SQL Server 2016中为我的数据库设置系统DSN(64位).当要求我选择驱动程序来设置数据源时，有以下选择:

I was setting up the System DSN (64 bit) for my database in SQL server 2016 with Windows 10 64 bit pro. While I was asked to choose the driver to set up a data source, there are the following selections:

• 用于SQL Server的ODBC驱动程序13
• SQL Server
• SQL Server本机客户端11.0
• SQL Server本机客户端RDA 11.0

似乎我可以使用所有这些驱动程序来设置数据源.那么从速度和效率方面我应该选择哪一个呢?它们之间有什么区别?

It seemed I can set up the data source with all of these drivers. Then which one should I choose in terms of speed and efficiency? What's the difference between them?

谢谢

Jason

推荐答案

用于SQL Server的ODBC驱动程序

ODBC是用于以C，C ++，PHP，Python和其他语言编写的应用程序的主要本地数据访问API，用于连接到SQL Server.

ODBC is the primary native data access API for applications written in C,C++, PHP, Python and others for connecting to SQL Server.

它广泛用于数据集成方案中.

It's widely used in data integration scenarios.

此外，如果要在Windows上开发应用程序并将其部署到Linux上，则是首选方法.

Also, it's preferred if you are developing application on Windows and deploying it to Linux .

SQL Server

SQL Server驱动程序的全名是SQL Server ODBC驱动程序.自sql 2000以来，它是一个旧的驱动程序. 您可以使用它来连接到SQL Server 2016，但是您将无法访问SQL Server 2016的新功能

The full name of SQL Server Driver is SQL Server ODBC Driver. It’s an old driver since sql 2000. You can use it to connect to SQL Server 2016, but you will not be able to access new features and functionality of SQL Server 2016

SQL Server本机客户端

SQL Server本机客户端同时包含SQL OLE DB提供程序和SQL ODBC驱动程序，以支持与SQL Server的本机连接并支持sql server 2016的所有功能. 在Windows环境中是最好的

SQL Server Native Client is containing both the SQL OLE DB provider and SQL ODBC driver to support native connectivity to SQL Server and support all features of sql server 2016. It's the best in windows environment

SQL Server本机客户端RDA

Microsoft SQL Server Compact 3.5中的远程数据访问(RDA)允许应用程序访问远程SQL Server数据库表中的数据.

Remote data access (RDA) in Microsoft SQL Server Compact 3.5 lets an application access data from a remote SQL Server database table.

它还可以在SQL Server Compact 3.5中存储，读取和更新该数据，然后更新原始SQL Server表.

It can also store, read, and update that data in SQL Server Compact 3.5, and then update the original SQL Server table.

RDA将在将来的版本中删除，因此请避免使用它.

RDA will be removed in the future release, so avoid using it.

因此，请根据以上条件选择sql驱动程序.

So choose sql driver based on the criteria above.

这篇关于ODBC驱动程序的驱动程序之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！