ODBC驱动程序SQLSRV32.dll与SQL Server版本的兼容性 [英] Compatibility of ODBC driver SQLSRV32.dll with SQL Server versions

问题描述

在哪里可以找到与名为"SQL Server"(SQLSRV32.dll)的标准ODBC驱动程序兼容的SQL Server版本的信息?

Where can I find the information with which SQL Server versions the standard ODBC driver named "SQL Server" (SQLSRV32.dll) is compatible ?

请确保它可以与Microsoft SQL Server 2008 R2一起使用，因为我们已成功使用它们.

For sure it works with Microsoft SQL Server 2008 R2 because we are using them successfully.

那下面呢?

• Microsoft SQL Server 2012
• Microsoft SQL Server 2014
• Microsoft SQL Server 2016
• Microsoft SQL Server 2017

不幸的是，几个小时后我无法使用自己喜欢的网络搜索引擎找到该信息. 在 https://docs.microsoft.com/zh-cn/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows 是可以下载的较新版本驱动程序的描述，但我们没有安装其中之一的管理员特权. 我们必须使用开箱即用安装在Windows上的标准ODBC驱动程序，因为该应用程序应在客户的台式PC上运行.

Unfortunately I could not find that information after hours using my favourite web search engine. On https://docs.microsoft.com/en-us/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows are descriptions of newer drivers which can be downloaded, but we don't have admin privileges to install one of them. We have to use the standard ODBC driver which is installed on Windows out of the box, because the application should run on customers desktop PCs.

此信息可能还取决于DLL的版本.作为示例，我们使用版本10.00.15063.00，但是由于上述原因，它可能会有所不同. 我们不完全知道客户使用哪个Windows版本.可以是[Win7，Win8，Win10]/[家庭/专业版/企业版].

Probably this information also depends on the version of the DLL. As an example let's take the version 10.00.15063.00, but it can vary, for the reason mentioned above. We do not exactly know which Windows versions the customers use. Can be [Win7, Win8, Win10] / [Home/Pro/Enterprise].

推荐答案

Windows附带的"SQL Server" ODBC驱动程序是

The "SQL Server" ODBC driver that ships with Windows is part of Microsoft/Windows Data Access Components (MDAC/WDAC) and is an operating system component nowadays. The specific driver version number shouldn't be a concern given that the interface is the same. This ODBC driver is deprecated and has not been enhanced since for many years. It is included with Windows only to support legacy applications and is unaware the new SQL data types and features introduced since the release of SQL 2005. It is not intended to be used for new development but nothing prevents you from using so.

大多数Java应用程序使用JDBC驱动程序进行关系数据库访问.您可以使用现代的JDBC驱动程序，并将其包含在您的应用程序中.这样您就可以使用更新的SQL功能.

Most Java applications use a JDBC driver for relational database access. You could use a modern JDBC driver and include it with your application. That will allow you to use newer SQL features.

这篇关于ODBC驱动程序SQLSRV32.dll与SQL Server版本的兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！