This discussion is archived
6 Replies Latest reply: May 27, 2011 5:32 AM by 856637 RSS

Oracle provider Oracle.DataAccess not find. Version - ODAC 4.112.2.0

856637 Newbie
Currently Being Moderated
Hello,

Please to help me!!!!...??? I don’t know more what to do.

I have an application ASP.NET, C# with access to the database Oracle by ODAC.
It was worked without problem on the platform x86. I have tried to put it on the server Windows 2008 R2 without of the success.

Than on the other PC I have installed:
-Windows 7 platform 64 bit.
-ODAC 11.2 Release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual Studio and I have put this -path in the system path
-Visual Studio 10
-Framework 2 (v2.0.50727) and 4 (v4.0.30319)
- I have configured IIS server two “Pools Classic” for Framework 2 and 4

In the debugging by Visual Studio 10 it is working with Framefork 4 and with use of Framework 3.5 too, by using the assembly (Version=2.112.2.0 or Version=4.112.2.0):
<add assembly="Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
In the web.config.

But it’s problem when I try to start it directly from IIS (it’s not changed if I use “batch build” AnyCPU, x86 or x64):

Erreur de configuration
________________________________________

Description : Une erreur s'est produite lors du traitement d'un fichier de configuration requis pour répondre à cette demande. Veuillez consulter ci-dessous les détails relatifs à l'erreur en question, puis modifier votre fichier de configuration de manière appropriée.

Message d'erreur de l'analyseur: Impossible de charger le fichier ou l'assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' ou une de ses dépendances. Le fichier spécifié est introuvable.

Erreur source:

Ligne 55 : <add assembly="Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
Ligne 56 : </assemblies></compilation>

Fichier source : C:\inetpub\wwwroot\fcharges_web\web.config Ligne : 55

Suivi du chargement de l'assembly: Les informations suivantes peuvent permettre de déterminer la raison pour laquelle l'assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' n'a pas pu être chargé.

=== Informations d'état de liaison préalable ===
JRN : utilisateur = IIS APPPOOL\FrameWork2_Classique
JRN : DisplayName = Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342
(Fully-specified)
JRN : Appbase = file:///C:/inetpub/wwwroot/fcharges_web/
JRN : PrivatePath initial = C:\inetpub\wwwroot\fcharges_web\bin
Assembly appelant : (Unknown).
===
JRN : cette liaison démarre dans le contexte de chargement de default.
…..

Equal error With Framework 4
________________________________________
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. Le fichier spécifié est introuvable.

Source Error:

Line 43: <add assembly="Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
Line 44: </assemblies></compilation>


Source File: C:\inetpub\wwwroot\fcharges_web\web.config Line: 43

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' could not be loaded.

=== Pre-bind state information ===
LOG: User = IIS APPPOOL\ASP.NET v4.0 Classic
LOG: DisplayName = Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342
(Fully-specified)
LOG: Appbase = file:///C:/inetpub/wwwroot/fcharges_web/
LOG: Initial PrivatePath = C:\inetpub\wwwroot\fcharges_web\bin
Calling assembly : (Unknown).
….
________________________________________

When I look to GAC, I don’t know exactly all of the links, but I think that all is in order :
________________________________________

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>gacutil /l
Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1
Copyright (c) Microsoft Corporation. All rights reserved.

The Global Assembly Cache contains the following assemblies:

System.Data.OracleClient.resources, Version=2.0.0.0, Culture=de, PublicKeyToken=b77a5c561934e089, pr
ocessorArchitecture=MSIL
System.Data.OracleClient.resources, Version=2.0.0.0, Culture=fr, PublicKeyToken=b77a5c561934e089, pr
ocessorArchitecture=MSIL
System.Data.OracleClient.resources, Version=2.0.0.0, Culture=it, PublicKeyToken=b77a5c561934e089, pr
ocessorArchitecture=MSIL

System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, process
orArchitecture=AMD64

Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArc
hitecture=x86
Oracle.DataAccess.resources, Version=2.112.2.0, Culture=fr, PublicKeyToken=89b483f429c47342, process
orArchitecture=x86
Oracle.Web, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitectu
re=x86
Oracle.Web.resources, Version=2.112.2.0, Culture=fr, PublicKeyToken=89b483f429c47342, processorArchi
tecture=x86

Policy.2.102.Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342,
processorArchitecture=x86
Policy.2.111.Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342,
processorArchitecture=x86
Policy.2.111.Oracle.Web, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, proces
sorArchitecture=x86
Policy.2.112.Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342,
processorArchitecture=x86
Policy.2.112.Oracle.Web, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, proces
sorArchitecture=x86
________________________________________

When I put Oracle.DataAccess.dll in the directory bin of the application the error is:
________________________________________

Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. Tentative de chargement d’un programme de format incorrect.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. Tentative de chargement d’un programme de format incorrect.

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Oracle.DataAccess' could not be loaded.

=== Pre-bind state information ===
LOG: User = IIS APPPOOL\Classic .NET AppPool
LOG: DisplayName = Oracle.DataAccess

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points