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.
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.
Hey dramus , can you please paste in the links for the downloads you performed? Both the Runtime and ODAC?
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.
So, I am really new to this stuff and there seems to be several files to download, can you refer me to the link in Oracel or file name of what I should download? Thanks for responding, your post is a few years old now lol
There are a couple of things to note when installing, see me replies above for details.
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.