Forum Discussion

RakeshP's avatar
RakeshP
Helper I
10 years ago
Solved

Having issues with Connect to Oracle database

Hi ALL,   I am trying to connect to oracle database from Power BI Desktop(PBID), but it is throwing below error.   Unable to connect   we encountered an error while trying to connect   Detail...
Need Help
anitaberg's avatar
anitaberg
Helper I
8 years ago

Hi! I have issue with the original issue. Details: "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." 

 

I have installed a complete test environment on my windows virtual PC, with Oracle database and Oracle business intelligence running.

 

Now I have installed the corresponding ODAC to the version of oracle database I have, I believe.

 

When I installed the ODAC software it created a client_2 in adition to the client_1 I hve in the c:app.... folder

 

My guess is that Power BI is looking in the client_1 folder for the dll to use, when it should have looked in client_2 as that was created with the ODAC 64 bit install.

 

Any help or tips on this?