Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

problem connecting to oracle

I am trying to connect to oracle from power bi, and getting this error

 

The recommended provider (oracle.dataaccess.client) is not installed.  You can continue with your current provider , howerver, it has been deprecated and may not work correctly.

 

I am trying to install ODAC for 64 bit from below url, 

 

https://www.oracle.com/database/technologies/odac-downloads.html

 

Is it the ODP.NET file that i need to download ? if I do that I get the message

 

" The files of this zip file are NOT to be installed on top of an existing Oracle Universal Installer (OUI) based Oracle Home installation."
 
Also, where can I find the odac driver in my machine if its already installed?

 

Need Help

1 Reply

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Please refer to this article. It should be helpful to you.

    And you also can refer this solved post.

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.