Forum Discussion
Cannot Connect to an Oracle Database...GOING INSANE, READY TO QUIT
Resident RockstarHi geofflilley,
Have you downloaded the Oracle client based on the official document here?
In addition, could you please upload the screenshots for your error messages?
Best Regards,
Cherry
"Have you downloaded the Oracle client based on the official document here?"
Yes. To reiterate in my original post, yes, several times. I clicked Learn More, got directed to that link, followed the directions to the absolute letter of the law, and I get the same error message, contained in this screenshot, which I quoted verbatim in my original post:
At first, I downloaded the 64-bit version, since I am running 64-bit PowerBI. Same error. I downloaded the 32-bit client as a precaution. Same error.
Trying to connect via ODBC gets me a different error, which, as previously stated, is "Restricted data type attribute violation. Details: DataSourceKind=Odbc." That's the one with dozens of posts on this forum to the effect of, "Yeah, me too, bummer, any help, Microsoft?" To wit:
ODBC Error
ODBC Connection 01
ODBC Connection 02ODBC Connection 03
So I can see the connection in PowerBI when I do it via ODBC, and I can get all the way to the screen where it looks like I can access a table, but then, when I actually go to select one, no dice.
The only thing I've gotten to work so far is the DevArt 3rd-party ODBC driver. It's slow as molasses in January, but it works.
I have a very large vested interest in making this work, since my company partners with MS, and we want to offer this as a viable solution to our clients, but when I as a sales engineer with a technical background, and presumed technical expertise, can't get this thing to work, I can't offer proof of value, so I'm kind of screwed right now. Please help.
- ChrisMendoza
This may not be of much help but when I was attempting to connect to my Oracle DB (pretty sure the Instructor had us start with 14) on AWS for a school project I had the same issue. I ended up upgrading to the newest release, at the time, of Oracle in a new instance. I know that is probably not an option for you however after upgrading everything to the most current it was able to connect. Oh, I vaguely remember something about creating an entirely new user/pass as well in one of the Oracle ODAC screens that was not my ADMIN or user account. It was odd but that could have been it as well. Since it was a school project I was just trying to get it done and unfortunately did not take the best notes on how I did it.
It was harder than it needed to be that's for sure. I thought it was because I am a student however even my instructor and local 'experts' couldn't provide assistance.
It can be done, is pretty much all the hope I can give you. Best of luck.
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.
- v-piga-msft
Hi geofflilley,
What's version of Oracle do you use? Please share your version of your Oracle Database.
Best Regards,
Cherry
