March 5, 2010

Oracle.DataAccess version numbers in a .NET config file

Filed under: Oracle — Darrin Maidlow @ 1:37 pm

For my future reference!

RADE and FullCircle and builds usually have the ODP.NET version in the web.confg set by the installer, but development builds usually come from my machine and are configured for use with the Oracle 11 ODP.NET.   If this is set incorrectly, you will get an error that looks a little something like this:

The IDbCommand and IDbConnection implementation in the assembly Oracle.DataAccess could not be found. Ensure that the assembly Oracle.DataAccess is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.

To use an different version of the Oracle client, the web.config must be edited and the QualifyAssembly section must have its version property set appropriately.  This will also apply for an app.config too.

   1: <runtime>
   2:     <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
   3:         <qualifyAssembly partialName="Oracle.DataAccess" fullName="Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
   4:     </assemblyBinding>
   5: </runtime>

Possible values for this are:

  • 11g: Version=2.102.2.20
  • 10g R2: Version=1.102.3.0
  • 10g: Version=10.2.0.100

Set your config appropriately and you’re good to go.

4 Comments »

  1. Thanks – that resolved the problem for me.

    Comment by GB FL — April 17, 2010 @ 6:11 pm

  2. Did you design the site this well with the default blog tools? Your blog is incredible.

    Comment by Pasquale Grames — September 20, 2011 @ 5:17 am

  3. hi,

    and versions ODP.NET 11.1.0.6.20 and ODP.NET 11.2.0.2.1 ?? which is Oracle.DataAccess version and Oracle version (10,11g,…)?

    thanks

    Comment by kiquenet — March 15, 2012 @ 4:55 am

  4. Thanks for the feedback! I’ve been meaning to update this post with more current versions of ODP.NET. Stay tuned, hopefully I can make time to do that soon ;)

    Comment by Darrin Maidlow — March 23, 2012 @ 3:57 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress

Switch to our mobile site