Forcing a .net application compiled for Oracle 9 to use Oracle 11

by Kevin Goff 17. April 2010 00:58

To get a server installed with the Oracle 11 ODP.net client to run an application compiled using the Oracle 9 ODP.net client requires a configuration change.  Out of the box the 11 client will work with the an application compiled with the 10 ODP driver but there is no policy configured to work with ODP 9.  To make this work add a specific assembly binding configuration to your configuration file of choice (I prefer machine.config for my configuration).

 

Keep in mind this has to be placed in both the Framework and Framework64 machine.configs in order to make both 64 and 32 bit apps use the 11 driver. 

 

Here is is what I used:

 

  1. <runtime>
  2.   <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
  3.     <dependentAssembly>
  4.  
  5.       <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342"/>
  6.       <bindingRedirect oldVersion="9.2.0.401" newVersion="2.111.7.0"/>
  7.  
  8.     </dependentAssembly>
  9.   </assemblyBinding>
  10. </runtime>

 

 

Tags: , , ,

Comments

7/14/2010 6:31:15 AM #

data match         

Hey very nice blog!! Man .. Beautiful .. Amazing .. I will bookmark your blog and take the feeds also..

data match       United States | Reply

9/3/2010 5:27:21 AM #

IP PBX

Great. i would have never have even thought about this if i would have never come across your post. incredible this could prove to bee of a huge utility and i just can't explain what an important topic you have come up with.you have come up with Seriously amazing topic. thanks for sharing this.

IP PBX United States | Reply

9/6/2010 9:44:52 AM #

Trade Forex

You have a very good site, well constructed and very interesting i have bookmarked you hopefully you keep posting new stuff, many thanks

Trade Forex Australia | Reply

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading