Oracle 32 Bit Drivers with 64 Bit

[Anonymous]

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

[Anonymous]

@Anonymous 

For us sometimes it helps to input the server name in connection screen of PBI as xx.xx.xx.xx/ServiceName

This is not dependant on TNSNames. Though it needs a Oracle driver of same bit.

[Anonymous]

I have fixed the driver issue, but now I get a error saying that there is no listener.

[Anonymous]

@Anonymous Have you tried the connection/server name this way

xx.xx.xx.xx/ServiceName

[Anonymous]

Hi All,

If anyone has this problem the correct format is <server name>:<port>/<service name> it finally works for me.

Thanks for the replies.

[Anonymous]

Hi,

I tried it, but it still doesn't work.

As you can see below, I have this pop up.

[v-lili6-msft · Accepted solution]

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:

• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4)

For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client:

• 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64

Please take a look at this document, it should be helpful to you.

Regards,

Lin