My application created connections, use them, close them, and dispose them properly. If you prefer the odac msi installer with managed odp. Stay tuned, hopefully i can make time to do that soon. Oracle database 11g release 2 for microsoft windows x64. Net only, choose one of the downloads from the beginners section. Dataaccess in any of the lists when trying to add an assembly oracle.
Oracle data access components odac for windows downloads. Press and hold windows key on your keyboard, then press button r. In the page to select a product to install, choose oracle data access. Net or they have more than one visual studio version installed. Menu oracle 11g r2 x64 client with odac installation guide 25 april 2011 on oracle 11g, odac install, x64, oracle. Oracle 11g r2 x64 client with odac installation guide.
In iis production server, i set 32 bit compatibility to false. Alternatively, you can simply upgrade to version 10. Some articles suggest to donwload the patch 6890831, but this is for the database server, and not for the client. Download the oracle universal installer odac version. Oracle will still need to be installed on the production or development machine in order to connect to oracle those libraries are greater than 100mb in size, so it didnt make sense to include them in a nuget package, but this package will at least allow the project to be.
The provider is not compatible with the version of oracle client. Dll library, but complains that all the other core. If this reference is required by your code, you may get compilation errors. Business key could not load file or assembly oracle. An attempt was made to load a program with an incorrect format. Providers assembly does not have a direct reference to the oracle database provider, and can be used with any version. This can also occur if the order of the install is reversed and the x64 version of the dataaccess assembly may be missing after installing oracle client.
Net assemblies stores its com dll versions hardcoded within. Select the file version you need to download, this tool will automatically download a complete file for you. The located assemblys manifest definition does not match the assembly reference. Copy the version specific com dlls to a different directory like \lib copy them into the build, as you build. It administrators can deploy odac in a streamlined fashion using the install technology they are most familar with.
If this all fails, i would recommend completely uninstalling the oracle odp. Version mismatch the majorminor version does not match or something similar. Net product version number and not the assemblydll version number. If installing odac into an existing oracle 12c home. Net and dependent unmanaged dll mismatch to enforce the usage of oracle. After this, change a reference to an appropriate version of the database provider for oracle, and recompile assemblies. The following is a straightforward guide to installing the oracle client and oracle data access components for windows 64bit clientsservers. Net framework 4 use the same unmanaged dll, oraops11w. Net at machinewide level option needs to be checked during the installation for the needed assemblies to get added to the gac. Do i have to install the 32 bit oracle client or simply 32 bit odp. Thank you for your help, ill upload the database, its running on sql server 2008 version 10.
1138 18 1514 1050 306 1289 772 1002 1663 1111 1304 1532 832 1636 1108 1525 1476 633 280 1697 338 410 1558 1654 1016 1192 467 1258 278 461 271 105