Unable to load 'Devart.Data.Oracle'
Posted: Thu 23 Apr 2015 08:47
Hello, i have develop an asp.net mvc app using dotconnect for Oracle and EF 6. It work perfectly on local Visual Studio. But when i try to deploy it on IIS 7.5 i have the error :
"The ADO.NET provider invariant with the name 'Devart.Data.Oracle' is not part of the computer or the application configuration file, or it can not be loaded. See inner exception for details"
The stacktrace :
In the /bin of the application i have put : devart.data.dll devart.data.oracle.dll and devart.data.oracle.entity.dll
In my web.config file i have :
I have tried to put in the app.config :
Any ideas of what is wrong ?
thanks
"The ADO.NET provider invariant with the name 'Devart.Data.Oracle' is not part of the computer or the application configuration file, or it can not be loaded. See inner exception for details"
The stacktrace :
Code: Select all
à System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderFactoryResolver.<GetService>b__0(ArgumentException e, String n) à System.Data.Entity.Infrastructure.DependencyResolution.DefaultProviderFactoryResolver.GetService(Type type, Object key, Func`3 handleFailedLookup) à System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory) à System.Data.Entity.Infrastructure.DependencyResolution.CachingDependencyResolver.GetService(Type type, Object key) à System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext() à System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) à System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext() à System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) à System.Data.Entity.Infrastructure.DependencyResolution.CompositeResolver`2.GetService(Type type, Object key) à System.Data.Entity.Infrastructure.DependencyResolution.DbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver, Object key) à System.Data.Entity.Core.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) à System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionStringSetting(ConnectionStringSettings appConfigConnection) à System.Data.Entity.Internal.LazyInternalConnection.TryInitializeFromAppConfig(String name, AppConfig config) à System.Data.Entity.Internal.LazyInternalConnection.Initialize() à System.Data.Entity.Internal.LazyInternalConnection.CreateObjectContextFromConnectionModel() à System.Data.Entity.Internal.LazyInternalContext.InitializeContext() à System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) à System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() à System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() à System.Data.Entity.Infrastructure.DbQuery`1.System.Linq.IQueryable.get_Provider() à System.Linq.Queryable.OrderBy[TSource,TKey](IQueryable`1 source, Expression`1 keySelector) à Ope.Repository.PdsRepository.GetListPdsNames() à GeoscienceOPEApplication.Controllers.ResultatsController.Search() à lambda_method(Closure , ControllerBase , Object[] ) à System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) à System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) à System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) à System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) à System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() à System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() à System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) à System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() à System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
In the /bin of the application i have put : devart.data.dll devart.data.oracle.dll and devart.data.oracle.entity.dll
In my web.config file i have :
Code: Select all
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="Devart.Data.Oracle" type="Devart.Data.Oracle.Entity.OracleEntityProviderServices,Devart.Data.Oracle.Entity, Version=8.4.333.6, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</providers>
</entityFramework>
Code: Select all
<system.data>
<DbProviderFactories>
<remove invariant="Devart.Data.Oracle" />
<add name="dotConnect for Oracle" invariant="Devart.Data.Oracle" description="Devart dotConnect for Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle, Version=8.4.333.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</DbProviderFactories>
</system.data>
thanks