查询标准ODBC驱动SQLSRV32.dll与SQL Server版本的兼容性及信息来源
Alright, let's tackle this question since you've already spent hours searching without luck. Here are reliable ways to get the exact compatibility info, plus some quick insights to save you time:
1. Microsoft's Official ODBC Driver Compatibility Documentation
The definitive source is Microsoft's own docs for ODBC drivers. You don't need external links—just search internally for "ODBC Driver for SQL Server Compatibility Matrix" within Microsoft's documentation portal.
A quick heads-up: SQLSRV32.dll is the legacy built-in ODBC driver (often referred to as ODBC Driver 1.0/2.0 or the Windows system-provided SQL Server ODBC driver). It has limited but functional compatibility with SQL Server 2012, 2014, 2016, and 2017. That said, it won't support newer features introduced in those versions—think columnstore indexes, JSON functions, or Always Encrypted. Basic connectivity and standard T-SQL operations should work fine, though.
2. Check the Driver Directly via ODBC Data Source Administrator
You can pull details right from your system:
- Open the ODBC Data Source Administrator by running
odbcad32.exe(search for it in the Start menu or run dialog). - Navigate to the Drivers tab, find the entry labeled SQL Server (this corresponds to
SQLSRV32.dll). - Note the driver version number. You can cross-reference this version with Microsoft's release notes to see which SQL Server versions it was certified to support at launch.
3. Microsoft Product Lifecycle Pages
Search for "Microsoft ODBC Driver for SQL Server Lifecycle Support" to find pages that outline supported server versions for each driver release. For the legacy SQLSRV32.dll, the support typically extends to SQL Server 2017, but again, only for core functionality.
A Quick Note for Your Use Case
Since you've confirmed it works with 2008 R2, you can expect basic connectivity to 2012–2017 to work. If your application relies on any features added after 2008 R2, though, you'll want to upgrade to a newer ODBC driver (like ODBC Driver 17 for SQL Server) to get full support.
内容的提问来源于stack exchange，提问作者Mayoares
