Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Unable to connect to Oracle database using OLEDB

Anonymous
Not applicable

‎22-05-17 10:52 PM

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?
0 Likes
7 REPLIES 7

DavidClark
Level 3

‎23-05-17 01:35 AM

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
0 Likes

Anonymous
Not applicable

‎24-05-17 12:06 PM

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;
0 Likes

DavidClark
Level 3
In response to Anonymous

‎25-05-17 02:36 AM

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

Anonymous
Not applicable

‎04-08-17 01:02 PM

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?
0 Likes

Anonymous
Not applicable

‎04-08-17 02:12 PM

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
0 Likes

JeffMills
Level 3

‎06-01-18 03:28 AM

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

MiliDoshi
Level 2
In response to DavidClark

‎30-01-20 02:38 PM

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
------------------------------
0 Likes