Hi all,
I am trying to execute a SQL query to get the count from Oracle DB. I have tried using Oracle MDA VBO for this, but it looks like it is compatible with Oracle 21c+ only. Thus, I have to look into other options.
- OLEDB
Connection string: "(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST="&[Hostname]&")(PORT="&[Port]&")))(CONNECT_DATA=(SID="&[ConnectionName]&")(SERVER=DEDICATED)));
User Id="&[Username]&";Password="&[Password]&";"
But it's throwing an error:
2. ODBC VBO
I am using this connection string: "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="&[Hostname]&")(PORT="&[Port]&"))(CONNECT_DATA=(SERVICE_NAME="&[ConnectionName]&")));User Id="&[Username]&";Password="&[Password]&";"
And, getting this error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Can anyone suggest me best way to connect the Oracle 19c DB with Blue Prism?
Thanks!
