locked
SQL 2016 SSRS can't connect to Oracle 11g RRS feed

  • Question

  • I have installed a SSRS 2016 running side-by-side with a n SSRS 2014.

    All reports on SSRS 2014 connect to an Oracle datasource without any problem.

    The same reports don't run in SSRS 2016.

    SQL 2016 RC3 installed. Oracle instantclient_11_2 was installed some time ago.

    The doc (https://msdn.microsoft.com/en-us/library/ms159219.aspx) says only Oracle Data Sources versions 10g, 9, 8.1.7 are supported, but I find this hard to believe. This would mean an older version of SQL Server supports a newer version of Oracle, please tell me that is not true.

    Thanks

    Geert

    Geert Vanhove DCOD ------ http://geertvanhove.wordpress.com/ ----------- Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

    Wednesday, May 4, 2016 12:47 PM

Answers

All replies

  • Hi Geert,

    Starting with SSRS2016 we are switching from using System.Data.Oracle connections from .net Framework (as its marked for deprecation) in favor of ODP.NET provider for oracle. The downside is that this is an external provider, so until it is installed in the server it will not be loaded/displayed by SSRS. This provider needs to be installed in the server machine (and client machine for SSDT-BI).  So you need different providers for each version of RS you have installed.

    This is the link for the latest

    http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

    Thanks,

    Chris


    Wednesday, May 4, 2016 8:55 PM
  • Hi Chris,

    I get the switching provider , It is a good evolution.

    I test Report Builder 2016 with Oracle 12c ODP.NET using Oracle Procedure and I have an issue.

    I cannot create dataset on Oracle procedure, I can select only text type command query. When I execute the dataset I get an ORA-00900 invaslid SQL statement.

    Could give advice about how to create dataset with Oracle store procedure .

    Best regards 

    Gaspard

    Wednesday, February 8, 2017 9:03 AM