How to setup a connection to Oracle Database with UiPath

Help
10

I could create the connection successfully. The above error was due to an additional space in the connection string in tnsnames.ora file…:joy::joy:

Steps followed are:

  1. Download oracle instant client (basic and odbc driver) - 32 bit
  2. Extract content of both to one folder
  3. Add the path of instant client folder to System variables (Path and TNS_ADMIN)
  4. Install instant client by running odbc_install.exe in instant client folder
  5. Create the tnsnames.ora file inside the instant client folder.
    **If u have the file in some other location, make sure TNS_ADMIN is pointed to that location.
  6. Go to Administrative tool and launch Admin tool for ODBC (32 bit)
  7. Create a User DSN by clicking Add button under User DSN tab
  • Select Oracle db
  • Click Finish
  • Provide a preferred name to dsn
  • Select server name from TSN name drop down
  • Provide server username
  • Click Test Connection
  • Provide the password and Ok

**Connection success message is received.

  1. In the connection wizard of UiPath, generate connection string by selecting Dsn name and then providing username, password and testing connection.
  2. On succesful connection, click OK
  3. Select System.Data.Odbc from drop down

This worked for me…:slight_smile:

@Jagdish2593, @varunk Thanks for the support…:slight_smile:

19 Likes