I set up the ODBC drivers on a Windows 2022 server but encountered an error stating ‘Couldn’t load Drivers/Unsupported type of Openlink Lite ODBC drivers.’ I verified that the PATH environment variable values are correct, but the drivers still aren’t loading.
I have attached the screenshort for all the PATH environment variable.!
Is this a 32-Bit or 64-Bit Windows operating system (OS) installation? As you can see from the error message, the OS is unable to load the driver which is more that likely related to the OS and Driver Type combination.
Are you trying to use a 64-Bit application to connect to a DBMS that’s only accessible via a 32-Bit driver? Am I also correct in assuming that this worked when using a 32-bit edition of Windows?
Finally, are you using our ODBC-ODBC Bridge or our ODBC-JDBC Bridge? If not, then what drivers are you using?
Your PATH environment variables screenshot shows you have our 32bit ODBC driver installed in Program Files (x86) , whereas your Java Run Time (jre) is installed in Program Files indicating it is a 64bit runtime, which is not compatible with a 32bit application, and would result in the driver cannot be loaded error being encountered.
To use our 32bit ODBC driver you would need to also install the 32bit Java run time, and either removed the 64bit installation or encore the 32bit installation (in Program Files (x86)) is first in the PATH environment variables, such that it is located first for loading by the driver.
The installation and configuration process is the same for ANY Windows version, thus if is works on Windows 2022 and not on Windows 11, you must have a misconfiguration some where.
So please provide details of configuration and error being encountered on Windows 11.