Forum Discussion
Solved
Unable to connect using Oracle database even after ODAC install.
I have 64bit December 2017 Desktop Installed. I have 64bit Oracle 12.1.0.2 runtime client installed (and can use SQLPLUS to connect to the database from the command prompt). I have installed ...
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.
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.