Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Paginated Report Builder Oracle Data Source Connectivity issues

Good morning,   I have downloaded the latest version of Paginated Reports (updated 10/28/2019). I have the 64-bit Oracle client installed, and I have no problem connecting to our Oracle datasource ...
Oracle Data Source Issue
Paginated Report Builder
Anonymous's avatar
Anonymous
Not applicable
6 years ago

i had same problem on 64bit laptop

 

i found this: https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15

 

after doing these steps

32-bit drivers for Report Builder

Report Builder uses Managed ODP.NET for authoring paginated reports. The following steps are only needed when using Oracle ODAC drivers 12.2 and later as they install by default to a non-machine-wide configuration for a new Oracle home installation. These steps assume you've installed the ODAC 18.x files to c:\oracle32 and the file version of your Oracle.ManagedDataAccess.dll is 4.122.18.3.

  1. On the Oracle download site, install the oracle 32 bit odac Oracle UI

  2. Register ODP.NET Managed Client to GAC:

    C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll

  3. Add ODP.NET Managed Client entries to machine.config:

    C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odpm /frameworkversion:v4.0.30319 /productversion:4.122.18.3

Then i added all my oracles connections into TNSNAMESORA and PBI report builder works fine now for oracle connections