title: Problems switching .NET project from unmanaged to managed ODP.NET assemblies
body: <p>I'm trying to switch my .NET project over to the manage oracle to make deployments easier.  However I'm getting the following error in my test Win Server 2013 environment:</p>
  
  <p><strong>Unable to determine the provider name for connection of type 'Oracle.ManagedDataAccess.Client.OracleConnection'.</strong></p>
  
  <p>Steps I've taken so far:</p>
  
  <ol>
  <li>Removed all Oracle.DataAccess dll's and references from the solution</li>
  <li>Added the <a href="http://www.oracle.com/technetwork/topics/dotnet/index-085163.html" rel="nofollow">Oracle Data Provider for .NET (ODP.NET) Managed Driver</a> in the NuGet package manager</li>
  <li>Switched all <code>Imports Oracle.DataAccess</code> statements over to <code>Imports Oracle.ManagedDataAccess</code></li>
  </ol>
  
  <p>I'm not getting any build errors, and the project runs fine locally.  However when deployed to the testing environment, I get this error.  The test environment is Windows Server 2012, and has a legacy Oracle 11.2.0 client tools installation present.</p>
  
  <p>This is my connection creation code:</p>
  
  <pre><code>Public Sub New()
      MyBase.New(
          New OracleConnection(
              ConfigurationManager.ConnectionStrings("Entities").ConnectionString),
          True)
  End Sub
  </code></pre>
  
  <p>Here are 3 different styles of connection configs that I have tried (both work locally, but yield the same problem on the test environment)</p>
  
  <p>(formatted for visibility)</p>
  
  <pre><code>  &lt;add 
        name="Entities"
        connectionString="
            Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=###.###.###.###)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=______)));
            User Id=_____;
            Password=_____;"
        providerName="Oracle.ManagedDataAccess.Client" /&gt;
  
    &lt;add 
        name="Entities"
        connectionString="
            Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=###.###.###.###)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=______)));
            User Id=_____;
            Password=_____;"
        providerName="Oracle.DataAccess.Client" /&gt;
  
    &lt;add 
        name="Entities"
        connectionString="
            Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=###.###.###.###)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=______)));
            User Id=_____;
            Password=_____;"
     /&gt;
  </code></pre>
  
  <p>Any help would be greatly appreciated!</p>