Unable to connect the oracle database in blueprism

[VinayGondesi]

Hi Team,

Unable to connect and open the oracle database from Blueprism. I am getting an error like OraOLEDB.DLL is not registered in your local machine.

I have different ways to connect and i am using sql Oracle developer to connect the database.
 Please help to me to resolve this issue..

And i am using the below provider to connect but no use.

Please share any video or else steps to connect the oracle database and i am newly learning the blueprism. Please guide me on this issue.


"Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=number))(CONNECT_DATA=(SERVICE_NAME=svname)));User Id=sys;Password=pw;DBA Privilege=SYSDBA;" 

------------------------------
Vinay Gondesi
------------------------------

[AmiBarrett · Accepted solution]

You may need to try the following in a command prompt as administrator. I suspect the path will change based on the version you're using.

1) Use the "cd" command to navigate to the location of your OraOLEDB.dll
2) Use the following command based on if you're using an x86 or x64 version or Oracle:
     64-bit Oracle: c:\Windows\system32\regsvr32.exe OraOLEDB.dll
     32-bit Oracle: c:\Windows\SysWOW64\regsvr32.exe OraOLEDB.dll

Alternatively, you can add the \bin folder of where you installed the Oracle client into your system PATH.

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

[lookman]

Hi Vinay.

Just to confirm, you are NOT trying to use Oracle for the BluePrism installation. BP only supports MSSS as the BP installation database.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------