Getting started with ODP.NET, Managed Driver
You can get started with ODP.NET Managed Driver by either using the Oracle Universal Installer (OUI), XCopy, or NuGet.
If you are using OUI: Follow the Oracle Universal Installer (OUI) steps to install ODP.NET, Managed Driver
If you are using XCopy: Download ODP.NET, Managed Driver
.zip file to a directory for staging the install. The .zip file contains a README file with XCopy installation instructions.
Run the
configure.bat script in one of the following directories:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.Inner Exception: Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize at Oracle.DataAccess.Client.OracleConnection.cctorStatckTrace.
Each directory contains an
unconfigure.bat if ODP.NET, Managed Driver needs to be unconfigured and removed from the machine.
If you are using NuGet: Download the ODP.NET NuGet package(s) and use NuGet Package Manager to install.
The following NuGet packages are available:
ODP.NET, Managed Driver Files
ODP.NET, Managed Driver consists of the following files:
See Also:
Oracle Database Installation Guide for Microsoft Windows for installation instructions
File Locations After Installation
The
Oracle.ManagedDataAccess.dll assembly is installed to the following locations:
.NET Framework 4:
ORACLE_BASE
ORACLE_HOME
odp.netbin4 directory
Note:
If the machine has the corresponding .NET Framework installed, then the Oracle.ManagedDataAccess.dll assembly is added to the Global Assembly Cache (GAC) as well. This is to ensure that existing applications can start using the newly installed ODP.NET version immediately. However, if this is not desired, be sure to remove the policy DLLs from the GAC.
Documentation and the
readme.txt file can be accessed through ORACLE_BASE
ORACLE_HOME
ODACDocDocumentationLibrarydocindex.htm .
Samples are provided in the
ORACLE_BASE
ORACLE_HOME
ODACsamples directory.
Active1 year, 5 months ago
First of all, I want to use the
Oracle.DataAccess.dll to use OracleBulkCopy .
I want to know all the dlls that I need to be able to read from a database and then perform a bulkcopy in Oracle. Currently, we are using only one dll to perform all the reads from databases, we are using
Oracle.ManagedDataAccess.Client . But I can't use it to perform a bulkCopy.
I don't want to install ODP.NET for the users, I want to include the dll directly in the program. So I want to know the minimum required dlls to be able to use the
Oracle.DataAccess.dll in 32bit and in 64bit.
I know that there are some old post about this, but it's quiet old and the listed dlls are out of date. I can't event find some of them.
I installed the ODP.net for ODAC12 and I retreived all the listed dlls in this post. I also tried with with this post. The listed dlls are pointing out the version 11.
I made a dummy project that opens a connection, reads a table and bulk it in another table. I copied the listed dlls from the posts in the root of the project and I included
Oracle.DataAccess.dll in the project.
When I run my program in 64 bit I get the following error:
Could not load file or assembly 'Oracle.DataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342'
When I run it in 32 bit, I get this error:
Oracle Dataaccess Client Download 64
Unable to load DLL 'OraOps12.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)'
The dlls that I included are:
You need to manually remove the Symantec Endpoint Protection 12.1 client from computers on Windows Vista, Windows 7, or Windows 2008 operating systems (32-bit or 64-bit). Note: After you complete all steps, you must restart the computer one final time, in. Manually remove symantec endpoint protection. This document describes how to remove the Symantec Endpoint Protection 12.1 client from Windows Vista, Windows 7, and Windows 2008 based operating systems, both x86 (32 bit) and x64 (64 bit), manually. Connecting existing clients to a new or reinstalled Symantec Endpoint Protection Manager: If it becomes necessary to uninstall and reinstall the Symantec Endpoint Protection Manager without preparing in advance for disaster recovery, it is possible to reconnect existing Symantec Endpoint Protection clients to a new manager installation.
Community♦
billybobbillybob
1,65433 gold badges2424 silver badges4343 bronze badges
3 Answers
I managed to make it work.
Client
Oracle Data Access Client
Oracle Dataaccess Client Download Free
Oracle Dataaccess Client Download Windows 10billybob
1,65433 gold badges2424 silver badges4343 bronze badges
I experienced similar problem; install oracle data access components (odac ODTwithODAC122010.zip) for solution.
engntsnengntsn
Looks like you did not install the Oracle Instant client (or any other version of Oracle Client). This is a prerequisite for unmanaged ODP.NET provider.
Oracle Odac Client
Install the Oracle Instant client and you are fine. Otherwise you will get nothing but trouble.
Wernfried DomscheitWernfried Domscheit
27.6k44 gold badges3535 silver badges6363 bronze badges
Not the answer you're looking for? Browse other questions tagged c#.netoracledllodp.net or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |