I don't know if this will help but I use ODBC Driver 17 for SQL Server (MSODBCSQL17.dll) with DAO DSN-less, this works on both Windows 10 and 11. But I am using newer releases of SQL Server than you are.

Have you tried using MS Access on Windows 11 to connect to SQL Server to see what drivers work with your older databases? (start with a DSN connection until you determine what works).