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: 

Connecting to Oracle DB with the OLEDB VBO

Anonymous
Not applicable

‎08-01-18 09:00 PM

Hi I am trying to use the OLE DB VBO with the 64bit version of Blue Prism 5.0.30.0 and I have an issue with the VBO. I setup Oracle Client and the Oracle 64 bit ODAC. This is on the 64 bit version of Windows 10. I can use Windows C# and system level tools to connect to the Oracle Database just fine but in Blue Prism it get the Provider Not Found Error. I've tried switching to the 32bit Oracle OLEDB provider and I lose all connectivity so 64 bit is my only real option. I read the knowledge base and they say to use the 32bit Ole DB provider. That doesn't make sense to me. Has anyone had any experience with this or similar issues. Any help would be greatly appreciated.    
0 Likes
2 REPLIES 2

Denis__Dennehy
Level 15

‎09-01-18 03:25 PM

I found this internal document that may be of help to you.  If not, I have previously hacked at the SQL Server object that comes with the product to turn it into an Oracle VBO - which might be another option for you (it used System.Data.OracleClient.OracleConnection instead of SQLConnection but appart from that it was pretty much the same and more feature rich because it had transactions).
0 Likes

JeromeDescreux
Level 3

‎16-01-18 04:28 PM

Hi, Facing exactly the same issue. Followed the steps detailed in the PDF in the Knowledge base ""How do I install and configure an Oracle OLEDB connection using ODAC on a PC to work with Blue Prism"" (ie. 32 bit xCopy version of ODAC) Using the UDL file the test connection is successful, but the very same connection string does not work when used in BP) My guess is BP is not looking at the right place for the Drivers DLLs but how can we change this?   Many thanks in advance
0 Likes