Olivier Muhring

Olivier Muhring

  • 1.5k
  • 262
  • 9.2k

ODP .NET - add a database reference

Sep 17 2018 11:04 AM
I'm currently working on a project in Visual Studio 2017. One of the used databases is an Oracle server.
 
To avoid using the classic .NET Oracle client, which has been deprecated, I've been trying to use ODP .NET.
 
I've installed it, next to my classical Oracle client. (I have multiple clients installed...)
 
Whenever I try to add a database reference to a Visual Studio project (I do all my Db work in Visual Studio) I get the following error:
 
 
 
Orace database resolution  here is done using LDAP, so I don't have a tnsnames.ora anywhere.  When I use the classical .NET Client I don't get this error, but with ODP .NET I do.
 
Every installed Oracle Client uses the same configuration, and I copied the configuration into the ODP .NET config folder, I still get the same error though.
 
Anyone here have any ideas?