Hi ,
i have a query which i could be able to successfully run and get results in oracle.
I am trying to execute the same query in UIpath but it is erroring…
steps followed:
1)connected to ODBC
2)Read text file(query is saved as a text file and called using the activity)
3)Execute query
this is where it is erroring.
Can anyone please help me with this?
Its urgent
Hi,
do you have configured Machine like in this post:
I have the machine configured as in this link and it started working for me.
After configure machine I set flow:
Connect Oracle SQL:
ConnectionString =
"Dsn=" +DBName_string+ ";uid=" +SQL_User_id_string+ ";pwd=" +SQL_pwd_string
ProviderName =
"System.Data.Odbc"
Execute Query:
Sql =
your_query_string
Disconnect
thanks for the reply .my issue got resolved with a different work around.
Could you let us know what solution worked to You?