Connecting to Oracle ODBC

[rangga.waskita]

trying to connect to oracle ODBC but got this error when run the sequence

What has been done,

1. Set up ODBC connection - Connection Succesful

2. Create Connection in Sequence - Test Connection Succeeded

But got the connection error when run the file
Connect: 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

[rangga.waskita]

@rangga.waskita

Set up ODBC connection - Connection Succesful

1. Set up ODBC connection - Connection Succesful
   

[rangga.waskita]

@rangga.waskita

Create Connection in Sequence - Test Connection Succeeded

2. Create Connection in Sequence - Test Connection Succeeded

[Srini84 (Srinivas Kadamati)]

@rangga.waskita

ORA-12154

@rangga.waskita

Check below post

Connecting oracle ODBC

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

Hope this helps you

Thanks

[bharathi_ganesan]

is this issue solved? Am facing the exact thing.