Forum Discussion
getting "oracle.dataaccess.client",
Dear all, I am a beginner in using Power BI Tool i have a problem in connecting to an Oracle Database i have Oracle Database version 9.2.0.1.0 installed on windows server 2003 i installed ...
Icey
Community Support
Community SupportHi EmadBsb_1 ,
Here are some posts may help you:
Unable to Install Oracle Client for use in Power BI desktop;
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
These guys/gals are sending you on a wild goose chase as this fixes the general issue people have with this error.
Your problem is a bit different. Oracle Database versions below 10 are not compatible with the the minimum version instant client MS checks for.
That's not to say that there aren't work arounds to make it work. In fact, I have gotten it to work by installing both clients and copying the old driver file into the newer instant client folder but renaming it to match the current version. This is completely a Your Mileage May Vary thing, and I don't condone this method of driver tomfoolery - but it has worked for me in the past when trying to maintain compatability after database upgrades.
Your problem is a bit different. Oracle Database versions below 10 are not compatible with the the minimum version instant client MS checks for.
That's not to say that there aren't work arounds to make it work. In fact, I have gotten it to work by installing both clients and copying the old driver file into the newer instant client folder but renaming it to match the current version. This is completely a Your Mileage May Vary thing, and I don't condone this method of driver tomfoolery - but it has worked for me in the past when trying to maintain compatability after database upgrades.