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

      • IanCockcroft's avatar
        IanCockcroft
        Post Patron
        6 years ago

        I did click OK, and entered credentils as usual.

        get this

         

         

         

         

         

         

         

         

         

         

        AAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHH.

        i have the 64 and 32 bit client installed

        PBI is sept 64