This discussion is archived
7 Replies Latest reply: Mar 31, 2012 12:54 AM by B_M_A RSS

The type initializer for 'Oracle.DataAccess.Client.OracleConnection'

B_M_A Newbie
Currently Being Moderated
Hi All,

I am facing a error while doing asp.net web configuration.I am getting the following error

System.typeInitializationException{"The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."}
Inner Exception{"The provider is not compatible with the version of Oracle client"}

Installed following on my system
Visual Studio 2008
oracle Database 10g Release 10.2.0.1.0
and
Installed Oracle 11g Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio version 11.1.0.6.20

Can Any one help me out in this

Thanks

basu
  • 1. Re: The type initializer for 'Oracle.DataAccess.Client.OracleConnection'
    gdarling - oracle Expert
    Currently Being Moderated
    Which version of ODP is your app actually using?

    10201 ODP relies on your PATH environment variable. If you install 10201 first, then add an 11g install, the 11g install will come before the 102 install in your path. If your app is using 10201 and that's the situation, either putting the 10201 home to the top in the Oracle Universal Installer, or manually adjusting your PATH so that the 10201 OH\BIN comes before 11g should resolve the issue.

    Hope it helps,
    Greg

    Edited by: gdarling on Mar 27, 2012 11:31 AM

    Also, you're actually using the ASP.NET providers then, as opposed to simply coding an ODP.NET app? If so, what version of ODP.NET does the app itself use?
    I'm not sure whether the ASP.NET stuff runs in the same process space as the app itself, but I suspect there may be a conflict trying to load multiple versions into the same process.
  • 2. Re: The type initializer for 'Oracle.DataAccess.Client.OracleConnection'
    B_M_A Newbie
    Currently Being Moderated
    Hi Greg,

    Thanks for the reply.

    The following Version of odp.net are available in the refernce of the applocation

    2.111.6.20 from the following location E:\app\100468\product\11.1.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll

    10.2.0.100 from location F:\oracle\product\10.2.0\db_2\BIN\Oracle.DataAccess.dll

    The following Version of asp.net are available in the refernce of the applocation

    2.111.6.20 from location E:\app\100468\product\11.1.0\client_1\ASP.NET\bin\2.x\Oracle.Web.dll

    Thanks and Regards

    Basu
  • 3. Re: The type initializer for 'Oracle.DataAccess.Client.OracleConnection'
    gdarling - oracle Expert
    Currently Being Moderated
    I didn't think you could add two references to different versions of the same dll. Anyway, I'd try removing the 10.2 reference so the app only uses 11106.20 instead, and see if that helps.

    Greg
  • 4. Re: The type initializer for 'Oracle.DataAccess.Client.OracleConnection'
    B_M_A Newbie
    Currently Being Moderated
    Hi Greg,

    As u said removed the multiple versions and with a single version getting follwing error when running the application.

    Parser Error Message: Could not load file or assembly 'Oracle.Web, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

    Source Error:


    Line 176: <healthMonitoring>
    Line 177: <providers>
    Line 178: <add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />
    Line 179: </providers>
    Line 180: </healthMonitoring>


    Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config Line: 178
  • 6. Re: The type initializer for 'Oracle.DataAccess.Client.OracleConnection'
    gdarling - oracle Expert
    Currently Being Moderated
    I'm not sure if "na" means "disregard, I figured it out", but the error you're getting now is that it's looking for *11.2* ODP. Did you previously have 11.2 installed? If so, and you removed it, did you also remove the policy files?

    Was the app compiled with 11.2?

    The best thing to do at this point may be to completely remove the oracle client software, and "start over" clean, and install only a single Oracle home, but it kind of looks like you also have a 10.2 database on that box?

    Note also that 10.2.0.1 ODP was only 1.x, and as of 11.1.0.7.20 and newer (ie, 11.2) ODP.NET, there is no more 1.x.

    You might want to open a SR with support and we'll give you a hand getting it all sorted out.

    Greg
  • 7. Re: The type initializer for 'Oracle.DataAccess.Client.OracleConnection'
    B_M_A Newbie
    Currently Being Moderated
    Hi Greg,

    Thanks a lot,It was helpfull to resolve the issue

Legend

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