Is ODP.NET Supported for Use With SQL Server Reporting Services (SSRS)? (Doc ID 1294161.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2
Generic Windows
Business Intelligence Development Studio (BIDS)
Business Intelligence Studio
SQL Server Reporting Services (SSRS) 2008 R2
Report Builder
Report Designer
Data Processing Extension (DPE)
Visual Studio

Symptoms

You are attempting to use the Oracle Data Provider for .NET (ODP.NET) with a SQL Server Reporting Services (SSRS) project from the Business Intelligence Development Studio (BIDS).  The Oracle Data Provider for .NET is installed and works fine outside of the SSRS project but does not show up as an available provider in the data source wizard of your SSRS project.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms