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",
        "ConnectionString=Data Source=1x.1x.xx.xx:1521;User ID=xxx;Password=xxxx",

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"}

Labels (2)
1 Reply
Acclaimed Contributor.
Acclaimed Contributor.

@Sree Ranga, 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

Reward community members who take time to respond and help.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.