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                ...
Need Help
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

IanCockcroft's avatar
IanCockcroft
Post Patron
6 years ago

Thanks

Tijn  This is what i have

is 17 right?

  • 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.

     

    • IanCockcroft's avatar
      IanCockcroft
      Post Patron
      6 years ago

      Moenie worry, ek kan die taal goei :)

       

      Do you have the full Oracle client installed?

      I am using sql developer. This connects easy.

       

      I will ask one of our oracle DBAs to  have a look

       

      thanks for your help

      ian

       

       

      • IanCockcroft's avatar
        IanCockcroft
        Post Patron
        6 years ago

        Hi Anonymous ,

        I got he oracle DBAs to install the full 32 and 64 bit client.

        The ODBC divers look like this:

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        But I still get  the same message.

        Any ideas?

        thanks

        Ian