Connecting oracle ODBC

Help
1

Oracle client(32 bit) has been istalled, Env variables for Path and TNS_Admin has been added properly and ODBC data source(32 bit) has been created successfully, using that data source I’m able to connect to oracle database - Connection is successful(with same TNS using for ui connection).
image

But when I try to connect db with UIPath, I’m getting error as:

ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed
image

Any ideas to resolve?

1 Like
2

@veena1127,

Welcome to our Community!.

Thanks for posting your query in UiPath Developer Forum.

Please check these links,

1 Like
3

If you place the DSN name and the service name or SID in the tnsnames.ora file, the above issue will resolve @veena1127

1 Like
4

@veena1127

Hi,are you able to connect succesfully after following the @HareeshMR Steps

1 Like
5

Hi all,

I have the same error when I’m executing UIPATH sequence. But not error when testing ODBC connection. Do you have any idea to fix it ?

Many thanks
Emmanuel

1 Like
6

Thank you everyone!!

Issue has been resolved.

  1. Please check tnsnames.ora, makes sure there is no space in between name/connection string.
  2. Check the version and bits of UiPath system, Your normal system and Oracle- Data source.
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.