Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to preview report in SSRS when connecting to Oracle database with ODT for VS2015

Glen HughesNov 16 2016 — edited Feb 3 2017

I'm having problems creating a report against Oracle with SSRS. I've installed Visual Studio 2015 (Update 3), SQL Server Data Tools (14.0.61021.0), and ODT for VS2015. I have a SSRS project in Visual Studio, and I am able to create a Shared Data Source to connect to my Oracle database. When I test the connection within the data source settings, the connection succeeds and everything looks as expected. However, when I create a report that uses the data source and attempt to preview the report, I get the following error:

An attempt has been made to use the data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services.

pastedImage_0.png

These reports worked prior to updating to the latest Update of Visual Studio and ODT tools, however we are receiving this error on all machines that have been updated. As a test, I have also created a new VM and installed only VS, SSDT, and ODT for VS2015; this environment also generates this error.

Does ODT for VS2015 support designing SSRS reports within Visual Studio?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2017
Added on Nov 16 2016
4 comments
3,447 views