LR_db_connect running in 64 bit mode with the 32 bit Oracle client components installed

Getting error while trying to connect to Oracle 19c Db with LR-Vugen 2020.

Already have installed oracle client for 19c - 64 bit

Script failing at this step:

 lr_db_connect("StepName=Connect to DB",
        "ConnectionName=TestingDB",
        "ConnectionString=Data Source=1x.1x.xx.xx:1521;User ID=xxx;Password=xxxx",
        "ConnectionType=ORACLE",
        LAST);

Getting below 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."}
vuser_init.c(25): Error (-17939): DB Connection failed {"Connect to DB"}

  • , it might be a system setup issue. You need to know what LR is doing (searching and finding) to get a better understanding of the error and to be able to identify what is wrong.

    A tool that saved by days with this kind of errors is process monitor (procmon.exe) from www.sysinternals.com (It is now owned by Microsoft). With this tool you can monitor all network, file, registry access on your system. You have complex search capabilities. So it takes some time to learn and understand (google might be your friend to learn).

    I suggest to filter on LR processes and see what *.dll are accessed. Check to see if your oracle DLLs are found, it not check your PATH, etc.

    Success, Erik