ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified


I am trying to connect oracle database using Connect activity, i have installation of ODBC and followed all the steps to setup environment variable.

The test connection seems to be ok in the configure setting wizard. But when i try to execute the flow in Uipath, it ends with error. Any help on this please?


Once i connected to a Oracle DB. It was required to install a Oracle driver for it. What really helped was to create an Access File which uses the same ODBC connection just as a simple table-viewer and for testing the connection. Use external data sources in Access.
After UiPath did not work, I simply connected UiPath to the Access file and made the queries against access. It is a bit dirty, but worked well.

Thanks for you suggestion, what i am looking for is something different not to create from Access to Uipath.

Its pretty straight forward - Wanted to connect oracle DB to uipath, test connection seems to be successful in uipath but while executing flow it ends up with error that i had mentioned already.

Any suggestions or help please?