- 3,708,737 Users
- 2,241,117 Discussions
- 7,840,566 Comments
Forum Stats
Discussions
Categories
- 9 Data
- 362.2K Big Data Appliance
- 3 Data Science
- 1K Databases
- 322 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 479 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.7K ORDS, SODA & JSON in the Database
- 408 SQLcl
- 32 SQL Developer Data Modeler
- 184.6K SQL & PL/SQL
- 20.9K SQL Developer
- 1.3K Development
- Developer Projects
- 31 Programming Languages
- 134.5K Development Tools
- 4 DevOps
- 3K QA/Testing
- 172 Java
- 3 Java Learning Subscription
- 6 Database Connectivity
- 64 Java Community Process
- Java 25
- 7 Java APIs
- 141.1K Java Development Tools
- 2 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 132 Java 8 Questions
- 86.1K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 5 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 80 LiveLabs
- 23 Workshops
- 7 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 6 Español
- 1.9K Japanese
- 2 Portuguese
ODAC installation for Visual Studio 2017?

Hi,
I'm using visual Studio 2017 Proffesional. Within it I installed Business Intelligence add-in, so that I can create reports (Microsoft Reporting Services).
We use Oracle 11.4g version, and my PC is OS Win 10.
Unfortunally I can't see my reports in preview mode, as I don't have installed proper ODAC driver. Errors are different kind, but they all refer to not being able to connect to Oracle DB:
"An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of reporting Services."
"The selected data extension 'ORACLE' is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports."
Given above description, can somebody tell me exactly which ODAC driver should I install on my PC ? Link to driver download would be great !
Thanks for help in advance!
Answers
I've published some instructions using the Reporting Services with Oracle Autonomous DB. The difference with on-premises DB should only be customizing the authentication features you use. The most likely step you are missing is running the OraProvCfg utility to register ODP.NET in the .NET configuration file. Here's the tutorial:
https://www.oracle.com/a/otn/docs/database/connecting-ssrs-to-oracle-adb.pdf
I recommend you use managed ODP.NET to make install and configuration easier. All ODP.NET19c versions support connectivity back to Oracle DB 11.2.0.4.
Hi Alex,
this isn't helping me much.
I still don't know which version of ODAC - or Xcopy as mentioned in your tutorial - should I install.
However I downloaded 64bit version as Win10 is 64bit and tried to follow your steps.
Unfortunally I didn't pass even step 1. Isn't there any simple installer file like "setup.exe" ?
In these days there should be something simple as this.
Any of the ODP.NET 19c versions will work.
Microsoft has a similar tutorial here covering the managed ODP.NET configuration part.
https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15
The Oracle tutorial is much more end to end, though it covers an Autonomous DB scenario.
To answer your other question, the ODT tools and Oracle DB Client installs use setup.exe or equivalent VSIX. However, neither performs the machine.config changes SSRS uses. In general, .NET data providers are no longer making automatic machine.config changes due to the global effect on existing apps. The preferred method is for developers to change the app's specific app.config file. However, that's only possible if the SSRS exposes a local app.config type file, which it does not.
That leaves customers with these instructions, which I agree can be clumsy to implement. However, SSRS is the outlier. It's not modernizing its data provider infrastructure to follow ADO.NET best practices. In fact, it's not clear when SSRS will support ADO.NET Core.