Unable to connect to Oracle database using OLEDB
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?
7 REPLIES 7
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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;
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-05-17 02:36 AM
Yes, that would cause an issue, glad to hear you resolved it.
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
------------------------------
"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
------------------------------