Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# Oracle VB.NET
hi everyone
i download   ODP.Net 11g
it's working with any previous release from oracle db or not?
thanks for any help
Posted 11-May-11 2:20am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Yes, ODP.NET is backwards compatible with previous Oracle versions (specifically, at least 9i Release 2 and later).
 
See the following entry from the ODP.NET FAQ[^]:
 
Q: Can ODP.NET be used with an Oracle8, Oracle8 i, or Oracle9 i Release 1 client?
A: No. You need to use the Oracle9 i Release 2 or higher client.
  Permalink  
v2
Comments
mostafa.elsadany at 12-May-11 8:17am
   
ok but when publish my site i have error
The provider is not compatible with the version of Oracle client
if i used oracle provider 10g is compatible with 11g db
thanks for your help
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

I think this is the same issue. It was an issue that the server had an older odp.net version than what I had on my pc. I installed 11.2 version and the version on the server was much older. I used a binding redirect in the web.config so the older version of odp.net would be used until we could upgrade.
This is what I added to the "runtime" section:
<dependentAssembly>
    <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342" culture="neutral" />
    <bindingRedirect oldVersion="2.112.3.0-4.112.3.0" newVersion="10.2.0.100"/>
</dependentAssembly>
 
Entire runtime section:
<runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
                <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342" culture="neutral" />
                <bindingRedirect oldVersion="2.112.3.0-4.112.3.0" newVersion="10.2.0.100"/>
            </dependentAssembly>
        </assemblyBinding>
    </runtime>
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 514
1 Gihan Liyanage 298
2 RyanDev 268
3 Sergey Alexandrovich Kryukov 223
4 Richard Deeming 185
0 Sergey Alexandrovich Kryukov 8,936
1 OriginalGriff 7,891
2 CPallini 2,603
3 Richard MacCutchan 2,121
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web03 | 2.8.140827.1 | Last Updated 21 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100