CODEWITHSUNDEEP
oracle-databaseoracle11godp.net
David P
David P

Reputation: 2083

ODP.NET with 11g Full Client Install

I am porting some server applications from .NET 2.0 to .NET 4.5. I thought it might also be a good idea to get rid of the dependency on the deprecated System.Data.OracleClient. However, my IT department seems pretty insistent on installing the full Oracle 11G client on the server, and then maintaining updates itself, along with updates to tnsnames.ora.

Can I still use ODP.NET without installing InstantClient, and just have it use the already existing full client? If so, are there any options the Server team would need to install with the full client install to make it work with ODP.NET? If so, should I use the Managed, or Unmanaged version of ODP.NET, and/or should I use an older version of ODP.NET for 11g?

I am developing in VS 2012 and in .NET 4.5. Any direction (along with download links) would be much appreciated!

Upvotes: 0

Views: 1128

Answers (1)

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59436

You question is a bit confusing.

ODP.NET Managed Driver does not require any Oracle Client installation. You should prefer it if it fulfills all your needs.

System.Data.OracleClient is deprecated since long time by Microsoft as you stated. However, like Oracle.DataAccess (ODP.NET) it requires an Oracle Client installation. So, Oracle InstantClient is required in any case (unless you use the ODP.NET Managed Driver). The Unmanaged ODP.NET is also available for Oracle version 12.

I also don't get the issue with tnsnames.ora. Both, System.Data.OracleClient and Oracle.DataAccess (ODP.NET) work with or without an tnsnames.ora file, it should not make any difference. See example connection strings for Microsoft and Oracle with and without tnsnames.ora.

Upvotes: 1

Related Questions