1

We recently install SSRS report server on a Windows Server 2016. We are trying to add a Oracle 9 instance as a data source of SSRS but we have not been succesful to do so. We installed:

  1. Oracle Client 11G R2
  2. ODAC 11G 32 bits
  3. ODAC 11G 64 bits

Yet, with this, Oracle was not available as a connection type on SSRS web portal. We tried then to add a new connection with Data Tools for SSRS and it 'worked', supposedly ... it was deployed and we were able to see it as a connection type. However, it still won't work.

On Microsoft documentation they say to use ODAC 12c, but, I know from past experiences that Oracle 9 isn't compatible with client version 12. Nevertheless, we also tried installing it, both 32 and 64 bits version and we still can't figure out how to use Oracle as a data source.

Mr. Wrath
  • 431
  • 1
  • 3
  • 13
  • You missed: Install the Data Provider for .NET 4. ref: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-2017 and https://docs.oracle.com/cd/E11882_01/win.112/e23174/InstallODP.htm#ODPNT150 – Brian May 03 '19 at 19:55
  • @Brian Hello, if I understand correctly, ODACs should includes ODP.NET for .NET 4. – Mr. Wrath May 03 '19 at 20:03
  • How did you install the Client and ODAC? Compare with this one: https://stackoverflow.com/questions/24104210/badimageformatexception-this-will-occur-when-running-in-64-bit-mode-with-the-32#24120100 – Wernfried Domscheit May 04 '19 at 09:49

1 Answers1

1

Have a look at this: Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)

enter image description here

enter image description here

#5 - For connections between 10.2 (or higher) and 9.2 the 9.2 end MUST be at 9.2.0.4 or higher. Connections between 10.2 (or higher) and 9.2.0.1, 9.2.0.2 or 9.2.0.3 have never been supported.

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110