Forum Discussion
Unable to connect using Oracle database even after ODAC install.
Alrighty...Finally got it to work.
Installed 64bit runtime client 12.2. Then installed ODAC122010_x64. INTO THE SAME ORACLE HOME.
By default ODAC tries to install itself into a new Oracle Home. Which doesn't work.
It looks like Oracle have removed the links for the Oracle 12.2 Client from thrir Software downloads page. You have to request it now.
I'll try installing with the latest version and report back here.
I couldn't get Power BI Desktop to work with the Oracle19 ODAC tools. However a clean install of The full ODAC tools for 12.2.0.1.1 did work. I didn't need to install an "Oracle Client" at all.
NOTE: Make sure to check the box about installing the drivers machine wide.
One more gotchya. I had to copy the oraons.dll from the main client directory into the client/bin directory.
More digging this morning. Found this on the Oracle website for the ODAC 19.2 install:
Machine-Wide Configuration
Machine-wide configuration is no longer supported beginning with ODAC 18c. Administrators can still place ODP.NET in the GAC and add the configuration section handler and DbProviderFactory information to machine.config manually if they wish to override ODP.NET settings for individual applications.
So it seems Power BI Desktop doesn't see the drivers because Oracle no longer installs them at the machine level. If someone smarter than me with ODP.NET knows how to add that machine level configuration, I would be interested in trying it out.
I have ODAC 19.3 working with some help from google. I'm going to post it as a new topic, rather than hide it down here, so that it's easier to find. Once I've posted it I will come back add add a link to it.