Forum Discussion
Cannot Connect to an Oracle Database...GOING INSANE, READY TO QUIT
Hi 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.