Forum Discussion

vakshi's avatar
vakshi
Frequent Visitor
9 years ago
Solved

Oracle connection error

Hi all,   I'm getting this error message when trying to get data from oracle DB. the error message appears when I choose "Oracle", Before choosing the relevant DB and user/password:   "The recom...
  • karthicg's avatar
    karthicg
    New Member
    9 years ago

    I am getting a message that for ODAC 12c Release 4 (12.1.0.2) installer we need Visual Studio. Which version of visual studio should we use? I tried the community version, and I still keep getting the same message.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi, you might be downloading and using the wrong connector, I had the same issue this week. 

      Try creating a tnsnames.ora file in the client-> clientsname-> oracle version->client_1->Network->Admin directory 

      Or use the ODCA wizard to create one: 

      http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html 

       

      If you prompted to install VS, that means you ahve installed the wrong connector from Oracle. 

      Maybe this will work for you as well. 

       

      I have written a post about my expirience: 

      http://www.yanaberkovich.com/Blog/connecting-powerbi-desktop-to-oracle/ 

      • ckavaslar's avatar
        ckavaslar
        Frequent Visitor
        8 years ago

        Thanks Yana, copying my tnsnames.ora file in the client-> clientsname-> oracle version->client_1->Network->Admin directory worked like a charm.

  • kskarthick's avatar
    kskarthick
    Advocate I
    8 years ago

    Thank you my issue also same is solved.

     

    We need to download this file "64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64" it will provide setp file install it configure it according to your credentials.