Managed ODP.NET driver does not show up in Data Source dialog

by

The generic answer to this question is “(Re)install ‘Oracle Developer Tools for Visual Studio’ (ODT)”. Simply getting ODP.NET from Nuget or from other sources is not enough to take advantage of Visual Studio integration. You must install ODT also.

Download “ODTwithODAC”:
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

Update 4/2018: If you are using Visual Studio 2017 Community edition, please upgrade to version 12.2.0.1.1 or later. That is the first version that works with VS 2017 CE: http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownloadvs2017-3806459.html

As you noticed, sometimes installations get munged. So if you do not see the driver in the dialogs or are getting generic (non-oracle ORA-) errors when you try to use features then you should reinstall ODT.

More Related Contents:

  1. Can you use Microsoft Entity Framework with Oracle? [closed]
  2. Does ODP.NET require Oracle Client installation
  3. Developing .NET Compact Framework apps in Post-2008 Visual Studio?
  4. BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed
  5. Is it possible to change the location of packages for NuGet?
  6. How do you share code between projects/solutions in Visual Studio?
  7. How exactly does the “Specific Version” property of an assembly reference work in Visual Studio?
  8. What does “exited with code 9009” mean during this build?
  9. How do I run Visual Studio as an administrator by default?
  10. How do I fix the Visual Studio compile error, “mismatch between processor architecture”?
  11. Conditionally use 32/64 bit reference when building in Visual Studio
  12. “The breakpoint will not currently be hit. The source code is different from the original version.” What does this mean?
  13. Targeting both 32bit and 64bit with Visual Studio in same solution/project
  14. Release generating .pdb files, why?
  15. Favorite Visual Studio keyboard shortcuts [closed]
  16. Bulk Insert to Oracle using .NET
  17. Getting the path of the current assembly
  18. Change C++/CLI project to another framework than 4.0 with vs2010
  19. Remote machines cannot connect to Visual Studio web server
  20. How can I read/write app.config settings at runtime without using user settings?
  21. Visual Studio 2013 doesn’t discover unit tests
  22. What is app.config for?
  23. Browsing the .NET Framework source code from Visual Studio
  24. Can the DebuggerDisplay attribute be applied to types one doesn’t own?
  25. How do I find the stack trace in Visual Studio?
  26. Web Services — WCF vs. ASMX (“Standard”)
  27. How to Share App.config?
  28. Getting the PublicKeyToken of .Net assemblies [duplicate]
  29. How do I prevent Visual Studio from renaming my controls?
  30. Found conflicts between different versions of the same dependent assembly that could not be resolved

Leave a Comment