Automate Oracle 19c using OLEDB or ODBC

chauhannaman98 — Thu, 11 Apr 2024 17:18:00 GMT

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!

Re: Automate Oracle 19c using OLEDB or ODBC

DCabril — Tue, 14 Oct 2025 19:32:27 GMT

Hello

Would it be too much trouble if you could send me the download link for the object that ORACLE uses?

topic Re: Automate Oracle 19c using OLEDB or ODBC in Digital Exchange

Automate Oracle 19c using OLEDB or ODBC

Re: Automate Oracle 19c using OLEDB or ODBC