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
dramirezkon's avatar
dramirezkon
Frequent Visitor
3 years ago

Hi, I'm trying to config but when I run 

OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll​

showme this error:

C:\oracle\odp.net\bin\4>OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll​
ERROR: File not found: oracle.dataaccess.dll?
Error: Referencia a objeto no establecida como instancia de un objeto.

 

Can you help me? 

NathanMarston's avatar
NathanMarston
New Member
3 years ago

I ran into the same error - what i found I had to do was put quotes around "Oracle.DataAccess.dll", exactly like he did with the first call to OraProvCfg.

  • IncrementalValu's avatar
    IncrementalValu
    New Member
    2 years ago

    I was still geting the error, even when utilizing quotes. i.e.

     

     

    OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:"Oracle.DataAccess.dll​"

     

     

     
    I instead used a variable to define the current path of Oracle.DataAccess.dll and then used that which seemed to work:

     

     

    set oracle19cprovider="C:\oracle\ora19c64\client\ODP.NET\bin\4"
OraProvCfg.exe /action:gac /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'
OraProvCfg /action:config /force /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.