Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Thanks
Tijn This is what i have
is 17 right?
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.
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
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
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
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |