topic Unable to connect Oracle Database in Product Forum

Unable to connect Oracle Database

HarishM2 — Thu, 12 Sep 2019 13:32: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: Unable to connect Oracle Database

ManasJena — Thu, 19 Sep 2019 23:01:00 GMT

Hi Harish,

We are working with Postgres . We go like this to establish connection.

1- Set Driver
2- Set Host and Ports
3- Test Connection
See if that works for you

------------------------------
Manas Jena
Sr Analyst
ZimmerBiomet
America/New_York
------------------------------

RE: Unable to connect Oracle Database

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

Hi Manas,

Thanks for your response. I fixed this error by installing ODAC(Oracle Data Access Component) Driver on my machine.

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