cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dramus Established Member
Established Member

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

Accepted Solutions
dramus Established Member
Established Member

Re: 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.

5 REPLIES 5
dramus Established Member
Established Member

Re: 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.

Community Support Team
Community Support Team

Re: Unable to connect using Oracle database even after ODAC install.

@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.
anitaberg Regular Visitor
Regular Visitor

Re: Unable to connect using Oracle database even after ODAC install.

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.

anitaberg Regular Visitor
Regular Visitor

Re: Unable to connect using Oracle database even after ODAC install.

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.

hersrud Frequent Visitor
Frequent Visitor

Re: Unable to connect using Oracle database even after ODAC install.

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