About Me

Having 12 years experience in Microsoft technologies.Since more than 7 years working in SharePoint technologies. Expert in providing consultation for SharePoint projects. Hands on with development and administration.

Friday 27 January 2017

How to connect to Oracle DB from Visual studio using ODP.NET (Oracle.ManagedDataAccess.dll)


Oracle introduced new dll to connect Oracle database from .NET.

  1. Down load latest ODP.net package from oracle site. You should download the correct version of package based on your visual studio version
  2. You can check the link for the right version
     
  3. After install you can find the Oracle.ManagedDataAccess.dll @
    D:\xxxxxxxxx\product\12.1.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll
     
  4. Add the dll as a reference to your project solution in Visual studio.
  5. using Oracle.ManagedDataAccess.Client;

No comments:

Post a Comment