OLEDB OraOLEDB.Oracle provider error

[dfvr1994]

Hey guys

I've configured connectivity to OLEDB following this tutorials:

https://help.blueprism.com/Installa...LEDB-VBO-to-connect-to-an-Oracle-database.htm

https://help.blueprism.com/Automati...-OLEDB-connection-to-work-with-Blue-Prism.htm

I've been able to install the ODAC files using cmd, I test connectivity using a test.udl file.


The problem I'm facing is that when I try the connection on BP, it says:

"'OraOLEDB.Oracle' provider is not registered on the local machine."

Please see attached screenshots.

Windows has connection to the DB, but BP doesn't "see" the ODAC .dll

I have also tried to register the OraOLEDB11.dll file manually using:

cd \oracle\product\11.2.0\client_64\BIN
c:\Windows\system32\regsvr32.exe OraOLEDB11.dll
C:\Windows\SysWOW64\regsvr32.exe \path\to\dll\OraOLEDB11.dll

I have had no luck.

Could anyone help me?

Thanks

 

[Kalyan Kadiri]

Hi Dear ,

Thank you for your Support!

I followed the same steps as mentioned, even I am getting the same error "'OraOLEDB.Oracle.1' provider is not registered on the local machine." Could you please check and help on this issue.

Please find the below details (my pc configuration) for your reference.

• Windows 10 64 Bit
• Blue Prism Version 6.5.0.12573
• Oracle 12c 12.2.0.1.0 64 bit
• ODAC 12.2.0.1.0 (Xcopy) 32-bit
• Microsoft Access database Engine 2010
• Connection String: "Provider=OraOLEDB.Oracle.1;Password=xdb;Persist Security Info=True;User ID=XDB;Jet Data Source=orcl" and "Provider=OraOLEDB.Oracle.1;Password=xdb;Persist Security Info=True;User ID=XDB;Data Source=orcl"

Let me know, if any further information required.

Thanks & Regards,
Kalyan Kadiri
+91-8790509200

 

[liminana]

Hello, I have exactly the same problem, did you get any solution¿

 

[Kalyan Kadiri]

Hello, I have exactly the same problem, did you get any solution¿

No I didn't get, I am checking for solution.

 

[Vimal25]

Which engine you want to connect with excel sheet like ACE or JET engine . Which version you want to connect with window like 7/10

 

[liminana]

I am trying to connect to an Oracle DB

 

[Kalyan Kadiri]

Which engine you want to connect with excel sheet like ACE or JET engine . Which version you want to connect with window like 7/10

Not excel, I want to connect Oracle DB and I am using Oracle 12c, Windows 10 64 Bit, ODAC 12.2.0.1.0 Xcopy 32 Bit and MS Access Database Engine 32 bit.
Please let me know, if any further information required.
Thank you!

 

[dfvr1994]

Hey guys, yeah. I found the answer.

0) Please make sure you install de ODAC drivers and follow the entire process described in the first two links I posted.

1) Make a Copy of the "Data - OLEDB" object, and add this to the Initialise block Code tab:

Private moConnection As OdbcConnection

2) Set your connection string as follows:

"Driver={Microsoft ODBC for Oracle};
Server=Bancs_Prod_IBM_REF;
Uid = "&[Username]&";
Pwd="&[Password]

3) Put this code on the "Open" action in the object:

If moConnection Is Nothing Then
moConnection = New OdbcConnection(ConnectionString)
moConnection.Open()
End If

4) Put this code on the "Get Collection" action:

Dim cmd As New ODBCCommand(SQL,moConnection)
Dim oDataAdapter As New ODBCDataAdapter(cmd)
Dim oDataSet As New DataSet()
oDataAdapter.Fill(oDataset)
Results = oDataSet.Tables(0)

5) Enjoy

Attached is the process flow.

Note:

- You put your query as usual on the "Get Collection" action/"SQL" Input.

 

[liminana]

I solved my problem, Blue Prism works only with 32bits ODAC. I also have the problem with PC environment variable, which was pointing to 64bit intallation. Solved that, works perfect.

 

[dfvr1994]

I solved my problem, Blue Prism works only with 32bits ODAC. I also have the problem with PC environment variable, which was pointing to 64bit intallation. Solved that, works perfect.

Nice to hear that, would you mind trying the code I posted just to see if it works on your setup? I'm asking this because I'm trying to find out if the error was due to the version of the Oracle Data Base Server. To what version are you pointing to?