这确实是不是意味着您的PC使用了古代版本的Windows 10; 似乎是更新ODBC驱动程序的最后版本(我使用Windows 10 21H2,而SQL Server ODBC驱动程序仍然显示为10.00.19041)。
TLDR: You need to update that PC to a newer version of Windows 10. According to Microsoft, the "SQL Server" ODBC driver included in Windows 10 Build 17763.1554 and later supports TLS 1.2.
Details: The legacy MDAC "SQL Server" driver comes bundled with Windows.
Note that the build numbers of the "SQL Server" ODBC driver in your screen shots exactly match the following Windows 10 build numbers:
10.00.14393: Windows 10 1607 (Redstone 1)
10.00.19041: Windows 10 20H1
This does not mean that your PC uses that ancient version of Windows 10; it seems to be the lastest version in which that ODBC driver was updated (I use Windows 10 21H2 and the SQL Server ODBC driver still shows up as 10.00.19041).
I had the same issue. The solution: Another computer with a working copy of this driver, have them open regedit32.exe and export [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server]
and
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\SQL Server].
On the machine that needs the driver, from administrative tools right click on Registry Editor and run as administrator. File import and import the 2 files exported above. Worked for me! (after days of looking). Credit goes to my boss.
发布评论
评论(3)
找到了这个位置。也许您可以使用这个?
更新:
根据该页面:驱动程序包含在“ Microsoft SQL Server 2008功能包”中。
这是: Microsoft SQL Server 2008 /a>
以及服务包的链接: sql Server 2008服务包4
Found this location. Maybe you can use this?
SQL Server Native Client 10.0 ODBC Driver
Update:
According to that page: The driver is included in the "Microsoft SQL Server 2008 Feature Pack".
This is at: Microsoft SQL Server 2008 Service Pack 4 Feature Pack
and the link to the service pack: SQL Server 2008 Service Pack 4
tldr :您需要将该PC更新为Windows 10的较新版本。根据Microsoft ,Windows 10中包含的“ SQL Server” ODBC驱动程序构建17763.1554,后来支持TLS 1.2。
详细信息:传统MDAC“ SQL Server”驱动程序与Windows捆绑在一起。
请注意,您的屏幕屏幕拍摄中的“ SQL Server” ODBC驱动程序的构建号与以下:
这确实是不是 意味着您的PC使用了古代版本的Windows 10; 似乎是更新ODBC驱动程序的最后版本(我使用Windows 10 21H2,而SQL Server ODBC驱动程序仍然显示为10.00.19041)。
TLDR: You need to update that PC to a newer version of Windows 10. According to Microsoft, the "SQL Server" ODBC driver included in Windows 10 Build 17763.1554 and later supports TLS 1.2.
Details: The legacy MDAC "SQL Server" driver comes bundled with Windows.
Note that the build numbers of the "SQL Server" ODBC driver in your screen shots exactly match the following Windows 10 build numbers:
This does not mean that your PC uses that ancient version of Windows 10; it seems to be the lastest version in which that ODBC driver was updated (I use Windows 10 21H2 and the SQL Server ODBC driver still shows up as 10.00.19041).
我也有同样的问题。解决方案:另一台带有此驱动程序的工作副本的计算机,让他们打开regedit32.exe和导出[HKEY_LOCAL_MACHINE \ SOFTWARE \ odbc \ odbcinst.ini \ sql Server]
和
[HKEY_LOCAL_MACHINE \ SOFTWORD \ WOW6432NODE \ ODBC \ ODBCINST.INI \ SQL SERVE]。
在需要驱动程序的机器上,从管理工具右键单击注册表编辑器并作为管理员运行。文件导入并导入上述2个文件。为我工作! (几天后)。归功于我的老板。
I had the same issue. The solution: Another computer with a working copy of this driver, have them open regedit32.exe and export [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server]
and
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\SQL Server].
On the machine that needs the driver, from administrative tools right click on Registry Editor and run as administrator. File import and import the 2 files exported above. Worked for me! (after days of looking). Credit goes to my boss.