ORACLE DB Connection help

Learning & Development Programs Reboot Your Skills 2021
, ,
1

Hi Team,

I am trying to connect to by Oracle DB. i saw lot of post about the same. However am not able to connect. Kindly help with the same. It will be helpful if we have document on the same.

Am using Microsoft ODBC Data Source (ODBC)
In driver: “driver={Microsoft ODBC for Oracle};server=xxxx;uid=xxx; pwd=xxx"

getting Error IM002. Datasource Name not found.

Kindly help. We have lot of Oracle DB automation on hold.

2

Hi,
Do you have:

  • the ODBC driver installed in a version compatible with the DB and do you have the Oracle Instant Client installed?

  • a User DSN created?

  • Created environment variables for the account?

    ORACLE_HOME = C:\app\product\11.2.0\client_1
    TNS_ADMIN = C:\app\product\11.2.0\client_1\network\admin

  • Added tnsnames.ora in: C:\app\product\11.2.0\client_1\network\admin ?

3

No what mentioned i dont have. Cna you guide me ?

4

My IT department deals with this.
All I can tell you is that you need to install on a machine (dev, robot) ODBC driver that will be compatible with the Oracle database version on the database server.

The rest of the setup steps are to go through my question list from the previous post:

  1. ODBC Driver + Oracle Instant Client
  2. Create DSN user and configure connection
  3. Create environment variables
  4. Add tnsnames.ora with configuration in: C:\app\product\11.2.0\client_1\network\admin
  5. Install UiPath.Database.Activities in Robot Project
  6. Configure Connection with Database