Forum Discussion
Cannot Connect to an Oracle Database...GOING INSANE, READY TO QUIT
That makes sense. On a lark, I tried re-installing ODAC using a newly formed user, in the screen in question. Didn't make any difference. But it was a good thought.
On the matter of the Oracle platform upgrade - wish I could. Were it up to me, I'd be running this thing on the most current version, but that decision is out of my hands.
Thanks for trying.
Resident RockstarHi geofflilley,
What's version of Oracle do you use? Please share your version of your Oracle Database.
Best Regards,
Cherry
I assume you're referring to the version of the Oracle database I'm accessing? 11g. That's something that I cannot control.
On an unrelated note; having just returned from a business trip to the South, there's a joke that says, all great stories from a Southerner begin with, "y'all ain't gonna believe this..."
So here's my "Y'all ain't gonna believe this" - I installed PowerBI and ODAC on my dev box, which had a pristine install of Windows 10 Pro on it (and almost nothing else). I created the ODBC connection to the same database in C:\Windows\System32\odbcad32.exe.
Once again, same "restricted data type attribute" trying to use the ODBC connection.
When I tried to connect via Oracle, using the named instance in the TNSNAMES.ORA file, it connected without any errors.
So the generic answer, I can see is, "there's something weird with your installation of Windows, since you installed PBI and Oracle on almost virtually identical hardware, and got a different result."
While I concur that's the case, my problem is, I'm gonna have a LOT of explaining to do if I have to bust out a second computer to demo the beauty of this feature. That doesn't really bode well for me.
So I'm lucky, most men would have broken both legs.