Forum Discussion

dramus's avatar
dramus
Continued Contributor
5 years ago

Getting Power BI Desktop to work with Oracle ODAC AFTER version 12.2

Power BI Desktop needs the Oracle data providers installed at the machine level. After ODAC 12.2, Oracle removed this option from the install, which means out of the box Oracle 18.x and 19.x ODAC ins...
Tips and Tricks
AnamPatel's avatar
AnamPatel
Resolver II
4 years ago

Can you please let me know the steps to uninstall an older version of ODAC?

dramus's avatar
dramus
Continued Contributor
3 years ago

To uninstall a version of ODAC. I haven't run this, but it should be close.

 

 

OraProvCfg.exe /action:ungac /providerpath:"Oracle.DataAccess.dll"

OraProvCfg /action:unconfig  /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319
  • IncrementalValu's avatar
    IncrementalValu
    New Member
    2 years ago

    I made a slight change but overall it works well, thank you!

     

     

    set oracle19cprovider="C:\oracle\ora19c64\client\ODP.NET\bin\4"
OraProvCfg.exe /action:ungac /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'
OraProvCfg /action:unconfig /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'

     

    *Note, your location of Oracle.DataAccess.dll may be different than what I am using.