Skip to Main Content
Forums

ODP.NET

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!

Does the current ODP NET 19 version support Oracle Database 11.2 in VS2017?

User_TYI9VOct 13 2020

I'm looking to upgrade my version of ODP from 12.2 to the current version as I've been having some issues with Kerberos authentication with Managed ODP NET. In the documentation I see some mixed answers on what database versions are supported. In the datasheet, it says that versions 11.2 and up are supported. On the ODAC/ODP download page for Visual Studio 2017 it says that versions 12.2 and up are supported. On The ODAC/ODP download page for Visual Studio 2015 it says that versions 11.2 and up are supported. Is this a typo, or is it correct that only 12.2+ versions are supported when using Visual Studio 2017 and ODP NET 19? I'm currently running Microsoft SQL Server Data Tools for Visual Studio 2017 SSDT v 15.9.26 with Microsoft NET Framework Version 4.8.03761.

I can't post links yet but the datasheet can be found on the main Oracle Data Provider for .NET page under Database / Technologies / Application Development / Oracle Data Provider for NET. in the Technical Information Section. The information for Visual Studio 2015 and Visual Studio 2017 downloads can be found by clicking on Download ODP NET via ODAC under the Downloads, Discussion Forum, and Sample Code section and then clicking on the respective links on that page it brings you to.
This post has been answered by Alex Keh-Oracle on Oct 13 2020
Jump to Answer

Comments

Alex Keh-Oracle
Answer

ODT does use ODP.NET to connect to the Oracle DB. However, it's not necessarily tested against the same DB versions that an ODP.NET version by itself is tested against. For all intents and purposes, consider ODT a separate product from ODP.NET with a separate set of backwards compatibility support with DB servers.
ODP.NET 19c is backwards compatible with Oracle DB 11.2.0.4.
Using ODP.NET in SQL Server Data Tools is a little tricky since it's a packaged app (and for some reason not particularly easy to use with generic .NET providers). I've posted a tutorial for using managed ODP.NET with SSDT in Visual Studio. These instructions apply to Autonomous DB, but can certainly applied to on-premises DB. Of course, you likely won't need to set up the wallet for TLS 1.2 if your on-premises DB doesn't use SSL/TLS. So, you can skip that step.

Marked as Answer by User_TYI9V · Oct 14 2020
User_TYI9V

Thanks for the clarification on that Alex. I went ahead and installed ODP.NET 19c, but unfortunately it did not resolve my issues. I did find your "Connecting Microsoft SQL Server Integration Services and Microsoft SQL Server Data Tools to Oracle Autonomous Database " tutorial, and it looks like I'm following all the pertinent steps in there. In particular, I'm trying to connect from an SSRS report project within SSDT. I'll create a separate question form my current issues.

Alex Keh-Oracle

Here are the SSRS to Oracle ADB instructions. They are similar to the SSIS instructions with the main difference the SSRS UI to connect to a DB.

1 - 3

Post Details

Added on Oct 13 2020
#odp-net
3 comments
5,378 views