<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Connecting to Oracle DB with the OLEDB VBO in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91596#M41574</link>
    <description>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.

&amp;nbsp;

&amp;nbsp;</description>
    <pubDate>Mon, 08 Jan 2018 21:00:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-01-08T21:00:00Z</dc:date>
    <item>
      <title>Connecting to Oracle DB with the OLEDB VBO</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91596#M41574</link>
      <description>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.

&amp;nbsp;

&amp;nbsp;</description>
      <pubDate>Mon, 08 Jan 2018 21:00:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91596#M41574</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-01-08T21:00:00Z</dc:date>
    </item>
    <item>
      <title>I found this internal…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91597#M41575</link>
      <description>I found this internal document that may be of help to you.&amp;nbsp; 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).</description>
      <pubDate>Tue, 09 Jan 2018 15:25:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91597#M41575</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-01-09T15:25:00Z</dc:date>
    </item>
    <item>
      <title>Hi,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91598#M41576</link>
      <description>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?
&amp;nbsp;
Many thanks in advance</description>
      <pubDate>Tue, 16 Jan 2018 16:28:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Connecting-to-Oracle-DB-with-the-OLEDB-VBO/m-p/91598#M41576</guid>
      <dc:creator>JeromeDescreux</dc:creator>
      <dc:date>2018-01-16T16:28:00Z</dc:date>
    </item>
  </channel>
</rss>

