I need to connect to a Oracle database using UiPath. Have been going through this trail. Still I am unable to setup a connection. As I understood there are two ways to connect, using different combinations of below.
Connection strings
- Connection String = Driver={Microsoft ODBC for Oracle};Server=10.3.4.xxx;
- Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=<service_name>))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)));Uid=;Pwd=;”
Driver Options
- System.Data.OracleClient
- System.Data.Odbc
But I am unable to figure out the correct way to setup the connection. There is an approach creating a DSN and installing a oracle instant client and severa steps.
Can someone help to figure out the steps to follow, inorder to setup the connection.
Note: My OS is 64bit. Only the 32bit version of Microsoft Odbc driver for oracle exist in my machine.