Forum Discussion
Oracle 32 Bit Drivers with 64 Bit
Hi All,
I am trying to connect to a Oracle DB using Power Bi desktop 64 bit. I have downloaded ODAC122011_x64 from the oracle site and configured the tnsname.ora with my server details. The file is on my C Drive C:\app\myname\product\12.2.0\client_1\Network\Admin\Sample
However I am getting the following error in Power Bi;
DataSource.Error: An error happened while reading data from the provider: 'Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.'
Details:
DataSourceKind=Oracle
DataSourcePath=(description=(address=(protocol=tcp)(host=xx.xx.xx.xx)(port=1553))(connect_data=(server=dedicated)(service_name=myserver)))
The only drivers I have installed are from the Oracle download which are 64 bit, so I am confused and sure not what the next step should be. There doesn't seem to be other drivers installed and there aren't any Oracle services running.
Thanks
hi, Anonymous
You need to install the recommended provider which can be found in following links.
For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:
For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:
Please take a look at this document, it should be helpful to you.
Regards,
Lin
6 Replies
hi, Anonymous
You need to install the recommended provider which can be found in following links.
For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client:
For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:
Please take a look at this document, it should be helpful to you.
Regards,
Lin