topic Yes, that would cause an in Product Forum

Unable to connect to Oracle database using OLEDB

Anonymous — Mon, 22 May 2017 21:52:00 GMT

I am trying to connect to Remote Oracle database(11g) using OLEDB VBO, I have made the necessary changes to the VBO, and got the ODAC client installed in local machine, set the System PATH environment variable as suggested in: https://portal.blueprism.com/customer-support/knowledge-base/how-do-i-configure-oledb-vbo-connect-oracle-database But still i am facing the same issue: OraOLEDB.Oracle' provider is not registered on the local machine. I have tried pointing to the oraoledb11.dll in the main page of VBO, but its unable to recognize it. Can you please advice how can i resolve this problem?

your connection string should

DavidClark — Tue, 23 May 2017 00:35:00 GMT

your connection string should look like this: ""Provider=OraOLEDB.Oracle;DataSource= (DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL= TCP) (HOST=""your host"")(PORT = xxxx)))(CONNECT_DATA= (SERVICE_NAME=""your service name"")));User Id=""your username"";Password=""your password

I am using 64-bit OS in my

Anonymous — Wed, 24 May 2017 11:06:00 GMT

I am using 64-bit OS in my machine and the Blue Prism software CPU architecture seems to be : 32-bit. I had installed 64-bit version of ODAC client . This seems to be the problem and was getting the issue with the provider. I have installed 32-bit ODAC client and used the TNS less form of connection string, its working fine. Provider=OraOLEDB.Oracle;Data Source=hostname:port/servicename;User Id=username;Password=password;

Yes, that would cause an

DavidClark — Thu, 25 May 2017 01:36:00 GMT

Yes, that would cause an issue, glad to hear you resolved it.

Hi i first got this same

Anonymous — Fri, 04 Aug 2017 12:02:00 GMT

Hi i first got this same error but not since i installed ODAC. However i got a new error: ""Internal : Could not execute code stage because exception thrown by code stage: ORA-12560: TNS:protocol adapter error"" I am using the string suggested in this thread. Any suggestions?

Worked now with updated

Anonymous — Fri, 04 Aug 2017 13:12:00 GMT

Worked now with updated string - the more complex one from this thread: ""Provider=OraOLEDB.Oracle;DataSource= (DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL= TCP) (HOST=""your host"")(PORT = xxxx)))(CONNECT_DATA= (SERVICE_NAME=""your service name"")));User Id=""your username"";Password=""your password

Has anyone successfully…

JeffMills — Sat, 06 Jan 2018 03:28:00 GMT

Has anyone successfully connected to Oracle 12c? If so, can you please provide the connection string? Appreciate any help you can provide.

RE: your connection string should

MiliDoshi — Thu, 30 Jan 2020 14:38:00 GMT

Hi david, to the above connection string you mentioned, receiving ORA-28009 error (connection as sys should be as sysdba or sysoper). Tried updating the CS to:
"Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.44.78.12)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=svname)));User Id=sys;Password=pw;DBA Privilege=SYSDBA;"
But this isn't working.
Any suggestions?

------------------------------
Mili Doshi
Business Consultant
Persistent Systems Ltd
Asia/Kolkata
------------------------------