MANAGED DRIVER WITH EF REPORTING "The specified store provider cannot be found in the configuration, or is not valid" EXCEPTION

(Doc ID 1939339.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Developer Tools for Visual Studio .NET - Version 12.1.0.1 and later
Oracle Data Provider for .NET - Version 12.1.0.1 and later
Microsoft Windows x64 (64-bit)

Symptoms

.NET application built with Managed ODP.NET driver and 32 bit EF in AnyCPU mode.  After deploying to 64bit target machine where Managed ODP.NET configured to 64bit reporting following error on application run.

The specified store provider cannot be found in the configuration, or is not valid. at System.Data.EntityClient.EntityConnection.GetFactory(String providerString)
  at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
  at System.Data.EntityClient.EntityConnection..ctor(String connectionString)
  at System.Data.Entity.Internal.LazyInternalConnection.Initialize()
  at System.Data.Entity.Internal.LazyInternalConnection.CreateObjectContextFromConnectionModel()
  at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
  at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
  at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
  at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
  at System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider()
  at System.Linq.Queryable.OrderBy[TSource,TKey](IQueryable`1 source, Expression`1 keySelector)
  at DistEngr.DAO.DBRepository.GetAllSubcategories()

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms