cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dramus
Responsive Resident
Responsive Resident

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 ODAC121024Xcopy_x64 into my oracle runtime client.

 

But I'm still getting "DataSource.Error: The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider."

 

Any ideas?

1 ACCEPTED SOLUTION
dramus
Responsive Resident
Responsive Resident

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.

View solution in original post

19 REPLIES 19
dramus
Responsive Resident
Responsive Resident

I have successfully installed ODAC 19.3 and got Power BI Desktop to talk to it. I've posted it as a new topic, so that it's easier to find.

 

Installing ODAC 19.3 

hersrud
Frequent Visitor

What worked for us here was uninstalling 12.2 and then installing 12.1 .  We grabbed the newest link off the oracle site without thinking about it, but I guess microsoft specifies the version for a reason.  Powerbi doesn't appear to play nicely with 12.2

dramus
Responsive Resident
Responsive Resident

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.

View solution in original post

Hey @dramus , can you please paste in the links for the downloads you performed? Both the Runtime and ODAC?

dramus
Responsive Resident
Responsive Resident

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.

dramus
Responsive Resident
Responsive Resident

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.

dramus
Responsive Resident
Responsive Resident

One more gotchya. I had to copy the oraons.dll from the main client directory into the client/bin directory.

dramus
Responsive Resident
Responsive Resident

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.

dramus
Responsive Resident
Responsive Resident

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.

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 

dramus
Responsive Resident
Responsive Resident

ODAC 12.2.0.1.1 installer 

 

There are a couple of things to note when installing, see me replies above for details.

Thanks, is this the only download needed? I try this and it will for a split second show an install then nothing works?

 

dramus
Responsive Resident
Responsive Resident

Yes, this is all you need.

dramus
Responsive Resident
Responsive Resident

Try watching this Youtube video.

Installing ODAC for Power BI 

THANKS THIS WORKED!!

dramus
Responsive Resident
Responsive Resident

Here's my post on getting ODAC 19.3 to work.

Hi! I believe I have the same issue. I installed ODAC and as a result I got a client_2 in addition to client_1 in the C:\app\client\windowsusername\product\12.2.0

 

Is this what you refer to as oracle home the the ODAC should have installed in client_1 folder. How do I achieve this in the installation? (I guess I have to specify some other than the default path).

 

I have installed a complete test environment on my virtual PC consisting of oracle database, oracle business intelligence servers. So I probaly have another scenario than end users that do not run the DB server and fusion middelware on the computer.

 

I have had a lot of problems during installation of these components but have always figures a way around it, so I guess you have found the answer to this final issue of the Power BI / Oracle test envrionment installation.

Thanks for the help. I now installed a second time (using VM machine I could revert to before the first installation) then I change the installation path to client_1 instead of client_2. I got past the messages saying I did not have correct ODAC installed.

 

I also now managed to get it work by having the two clients client_1 and client_2. I then used the downloadable PBI client and isntalled ODAC with the tick for sharing installation on the machine.

@dramus,

 

This might be beneficial to other community members, you may help accept the solution above. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.