Unable to connect Oracle Database

[HarishM2]

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
------------------------------

[ManasJena]

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
------------------------------

[HarishM2]

Hi Manas,

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

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