Unable to Connect to ORACLE DB

[Amit_KumarSahoo]

Hi, I am facing issue in connecting to the ORACLE DB. Could someone please explain the process to connect to the ORACLE DB. And what component has to be installed on the system to do so.

------------------------------
Amit Kumar Sahoo
Assistant Software System Engineer Trainee
TCS
Asia/Kolkata
------------------------------

[PratyushGarikap]

Hi Amit,

There's a KB article explaining the connection setup which might be helpful - How do I configure the OLEDB VBO to connect to an Oracle database?



------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------

[Amit_KumarSahoo]

Hi , I am still facing problem in connecting with the Remote Oracle DB even after installing the 32bit ODAC component. The screenshot of the same has attached. Please do help in this context

------------------------------
Amit Kumar Sahoo
Assistant Software System Engineer Trainee
TCS
Asia/Kolkata
------------------------------

[PratyushGarikap]

You probably need to install/register the OLEDB dll. See below links -
https://community.oracle.com/thread/3999446
https://stackoverflow.com/questions/12903366/oraoledb-oracle-provider-is-not-registered-on-the-local-machine

------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------