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

[SaumitraSharma]

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

[HarishM2]

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

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