Error: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
Environment: I am running Oracle 23ai in Docker. I am able to connect to it from Powerbuilder and other apps running in MacOS (Sequoia 15.1.1 (24B91) - MacBook Pro M3 Max/ Parallels running Windows 11 pro.
I can connect to MSSQL server 2022 running in Docker from Visual Studio 2022.
I even created another Parallels VM running Windows 11 Pro and downloaded VS2022 community edition to it.
I downloaded ODAC23.5Xcopy_x64 and ran the setup. I am using the Oracle Instant Client that was in the ODAC23.5Xcopy_x64 folder.
I copied the Oracle client in ODAC23.5Xcopy_x64 to C:\ora23ai_instantclient and ran the ODAC23.5Xcopy_x64 install batch file.
I checked that the files in the instant client are 64 bit and they are.
Nothing has worked.