cliv

I maintain an application that I developed over 20 years ago in vb6. The application uses DAO to access databases on two old servers running SQLServer2005 and SQLServer2008. It is installed on nearly 50 computers with operating systems ranging from WinXP to Win10 and runs smoothly. The program uses DAO and ODBC DSN-less connection strings to access data using DRIVER={SQL Server}. The last driver that worked in Windows 10 and with SQL Server 2005/2008 was sqlsrv32.dll version v.10.0.19041.6456. After PCs started updating to Windows 11, it no longer works. On Windows 11, Microsoft ships a newer sqlsrv32.dll (now v.10.0.26100.3624) that has hardened TLS/SSL behavior, which breaks connectivity to SQL 2005. I thought about manually registering the old driver alongside the new one in ODBC. What I've done so far in Win11: 1. Activate TLS 1.0 (SQL Server 2005 speak TLS 1.0 only, SQL Server 2008–2012 TLS 1.0 / 1.1 / partial 1.2) 2. The old driver after update is in "C:\Windows.old\Windows\SysWOW64\sqlsrv32.dll", so i create a new entry in registry with a new name {SQL Server (Legacy)} and that location: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\SQL Server (Legacy)] "Driver"="C:\\Windows.old\\Windows\\SysWOW64\\sqlsrv32.dll" "Setup"="C:\\Windows.old\\Windows\\SysWOW64\\sqlsrv32.dll" "ResourceFile"="C:\\Windows.old\\Windows\\SysWOW64\\sqlsrv32.rll" "UsageCount"=dword:00000001 "DriverODBCVer"="02.50" "APILevel"="2" "ConnectFunctions"="YYY" "SQLLevel"="1" "FileUsage"="0" "CPTimeout"="60" [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers] "SQL Server (Legacy)"="Installed" 3.Reboot 4. Open C:\Windows\SysWOW64\odbcad32.exe -> Drivers tab -> confirm “SQL Server (Legacy)” -> appears ... but when i try to create a DSN using [SQL Server (Legacy)] ... fail. I also try the same (manual extract and register) with driver {SQL Server Native Client 11.0} sqlncli11.dll v. 11.4.7001.0, and sqlnclir11.rll in c:Windows\SysWOW64\1033\, because 32bit version cannot install using installer on Win11. Driver appear in Drivers tab -> “SQL Server Native Client 11.0” but create a DSN fot test fail also. Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\SQL Server Native Client 11.0] "Driver"="C:\\Windows\\SysWOW64\\sqlncli11.dll" "Setup"="C:\\Windows\\SysWOW64\\sqlncli11.dll" "ResourceFile"="C:\\Windows\\SysWOW64\\1033\\sqlncli11.rll" "DriverODBCVer"="03.80" "APILevel"="2" "ConnectFunctions"="YYY" "SQLLevel"="1" "FileUsage"="0" "CPTimeout"="60" "UsageCount"=dword:00000001 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers] "SQL Server Native Client 11.0"="Installed" I cannot update SQLServer because they are used in an industrial automation project and the app has become too complex over time so also update is dificult. Any suggestion please!