Forum Discussion

IanCockcroft's avatar
IanCockcroft
Post Patron
6 years ago

Connect to ORACLE

Hi guys,

ORACLE!!!!!!!!!!!!!!!

I   have found, read and actioned all the solutions I found on the forum to no avail. 

I still get this when selecting an oracle source

 

 

 

 

 

 

 

 

 

 

 

I then try use he old connection and get this

 

 

 

 

 

 

 

 

 

 

I have installed the new ODAC. But PBI doesnt seem to know that.

How do I set/tell PBI which ODAC to use?

Whats going on?

Can someone help pleeeeeeeeeeeeeeeeesssseeeeeeeeeee

so frutrated

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Make sure you have the 64 bit version of the Oracle client installed. Verify this by opening the "ODBC Data Source Administrator (64-bit)). 

     

    You need the appropriate version of the oracle driver in there. I.e. "Oracle in OraClient12Home1"

     

     

    You can find it by searching the name in the start menu. 

    Afbeeldingsresultaat voor odbc data source administrator drivers 64 bit

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hey, 

         

        That's for SQL server, so it looks like you're missing your Oracle driver. I posted a screenshot I found online which was in English, as my machine is Dutch. But as you can see I've got the OraClient driver in my 64 bit drivers list. 

         

         

         

        Here is the instant client download page

         

        Make sure to choose Instant Client for Windows x64 bit.