topic Unable to connect with Oracle Remote Database in Product Forum

Unable to connect with Oracle Remote Database

amit_1996 — Fri, 12 Jul 2019 07:04:00 GMT

Hi , I am

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

RE: Unable to connect with Oracle Remote Database

david.l.morris — Fri, 12 Jul 2019 10:13:00 GMT

How much have you Googled this? It would be helpful to know what troubleshooting you've tried. I see that you tried installing ODAC, but from glancing around on the interwebs, it looks like other people have also had to make an entry in the tnsnames.ora file. See here on the msdn forums. And are you sure you need the 32-bit version of ODAC? Here's another suggestion as well regarding registering the installed provider through command prompt.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: Unable to connect with Oracle Remote Database

amit_1996 — Fri, 12 Jul 2019 11:26:00 GMT

Hi David, Thank you very much for your reply on this...Could you explian this ORACLE remote Database connection with a complete step by step demo on your youtube channel..I am a subscriber of your channel.

In Blue Prism techchart community How do I configure the OLEDB VBO to connect to an Oracle database?

they mentioned that 32bit driver is more reliable than 64bit. And I am not sure how to configure the tnsnames.ora.

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