OraOLEDBpus12.dll: The specified module could not be found issue

Ask general questions here.
chiranthurs
Posts: 19
Joined: Mon Oct 29, 2018 1:09 pm

OraOLEDBpus12.dll: The specified module could not be found issue

Post by chiranthurs » Thu Feb 14, 2019 2:08 pm

Hi Team,

We are getting the "OraOLEDBpus12.dll: The specified module could not be found issue" and the report fails with the error "The 'OraOLEDB.Oracle' provider is not registered on the local machine". while connecting to Oracle 12c database. We dint get this issue while working on Ranorex 5.3.2 but getting it on Ranorex 8.3.2. Can you please help. I will attach the report and screen short for the same.

Regards,
Chiranth
Attachments
Database error.png
Database error.png (115.35 KiB) Viewed 2752 times

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 5052
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by odklizec » Thu Feb 14, 2019 2:51 pm

Hi,

I don't think this issue is directly related to Ranorex? It rather seems to be a problem with 32/64 bit installation of Oracle db, eventually, corrupted Oracle DB installation?

Check these posts:
https://stackoverflow.com/questions/129 ... al-machine
https://powerbi.microsoft.com/en-us/blo ... egistered/
And even more here:
https://www.google.com/search?client=fi ... istered%22

If I may guess, Oracle DB installed on your machine is 64bit, but Ranorex test is compiled and started as 32bit? And this is probably a root cause of the problem? Try to either run the test as 64bit or install 32bit version of oracle DB. Hope this helps?

BTW, 64bit debugging is currently not supported by Ranorex Studio.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

chiranthurs
Posts: 19
Joined: Mon Oct 29, 2018 1:09 pm

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by chiranthurs » Thu Feb 14, 2019 2:59 pm

Tried running by compiling as 64 bit but getting the error. Attaching screen shot.
Attachments
sixfour.JPG
sixfour.JPG (25.25 KiB) Viewed 2747 times

chiranthurs
Posts: 19
Joined: Mon Oct 29, 2018 1:09 pm

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by chiranthurs » Thu Feb 14, 2019 3:04 pm

I Ran the test suit without debbuger it compiled and ran. But i get the same error as before OraOledbpus12.dll not found. But this file is physically present on the machine and i can see it and also it is added in env variable. Still cant understand how it is not able to find this .dll file.

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 5052
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by odklizec » Thu Feb 14, 2019 3:16 pm

Hi,

Yes, as I've mentioned, Ranorex currently does not support debugging in 64bit mode. Hence the 64bit debugging error.

As for the not found error, the answer is most probably here:
OleDBError.png
OleDBError.png (126.71 KiB) Viewed 2746 times
It does not matter the file physically exists on HDD. The problem is, that the file is most probably not registered in the system! Have you recently updated windows or installed/uninstalled something (windows updates, oracle db, etc...)? I would suggest to reinstall OracleDB, which should eventually fix the issue. Alternatively, follow the steps in posts I mentioned above.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

chiranthurs
Posts: 19
Joined: Mon Oct 29, 2018 1:09 pm

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by chiranthurs » Fri Feb 15, 2019 6:29 am

Hi,

We have not installed any of the microsoft or oracle components on the machine. We only uninstalled Ranorex 5.3.2(where it was working fine) and installed Ranorex 8.3.2, apart from this there has been no changes on the VM. Also i created TestConnection.udl file and was able to connect successully to the db with "Oracle provider for OLE DB" which means the oracle provider is working fine. Screen shot attached.

Regards,
Chiranth
Attachments
DB connection Success.png
DB connection Success.png (105.61 KiB) Viewed 2741 times

User avatar
Support Team
Site Admin
Site Admin
Posts: 11957
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by Support Team » Fri Feb 15, 2019 8:09 am

Hello,

We indeed had difficulties with the OLE driver when using it with Ranorex 8.3.2.

Please update to Ranorex 9.0, which contains a related bug fix.

Let us know if that resolves the issue on your side.

Sincerely,
Robert
.
Image

chiranthurs
Posts: 19
Joined: Mon Oct 29, 2018 1:09 pm

Re: OraOLEDBpus12.dll: The specified module could not be found issue

Post by chiranthurs » Fri Feb 15, 2019 12:05 pm

Hi Robert,

Installing Ranorex 9.0 fixed the issue. I am able to connect to the DB now. Thank you so much.

Regards,
Chiranth