6 Replies Latest reply: May 27, 2011 7:32 AM by 856637 RSS

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

    856637
      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