topic RE: Not able to connect oracle Database in Product Forum

Not able to connect oracle Database

HarishM2 — Thu, 12 Sep 2019 13:29:00 GMT

Hi,

I am trying to connect Oracle Database . Using Default VBO Data- OLEDB Set connection and it is throwing some error.

"Internal : Could not execute code stage because exception thrown by code stage: The 'OraOLEDB.Oracle' provider is not registered on the local machine"

Below are the inputs I gave for OLEDB

Database:- "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =localmachine)(PORT = 1234)))(CONNECT_DATA =
(SERVICE_NAME = MDS)) )"
Password:- password
Provider:- "OraOLEDB.Oracle"
Connection String:- "Provider=OraOLEDB.Oracle;"(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =localmachine)(PORT = 1234)))(CONNECT_DATA =
(SERVICE_NAME = MDS)) )";User Id=""user name"";Password="password"""

Is there any other way we can connect Oracle Database through Blue prism?

Thanks,
Harish

------------------------------
Harish kumar
RPA Developer
------------------------------

RE: Not able to connect oracle Database

SaumitraSharma — Fri, 13 Sep 2019 07:58:00 GMT

Hi Harish,

If you receive the message: "'OraOLEDB.Oracle' provider is not registered on the local machine" this indicates that the OLEDB Oracle Data Provider cannot be located.

This may be due to the location of the required files in respect of their installation directory (e.g. 32-bit vs 64-bit install locations). It may also indicate that the OLEDB Provider for Oracle is not installed. The provider can be installed via the Oracle Data Access Components (ODAC).

ODAC for 64-bit operating systems: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

ODAC for 32-bit operating systems: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------

RE: Not able to connect oracle Database

HarishM2 — Wed, 20 Nov 2019 13:19:00 GMT

Thanks Saumitra. I fixed this error by installing ODAC component as you mentioned.

------------------------------
Harish
RPA Developer
------------------------------