Stack Overflow
Stack Overflow

Questions tagged [odp.net]

Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database.

Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security.

ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not available from other .NET drivers, including a native XML data type, self-tuning, RAC-optimized connection pooling, promotable transactions, and Advanced Queuing.

ODP.NET home page for news, downloads and help: http://otn.oracle.com/dotnet

1296 questions
161
votes
27 answers

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle client" error message. Any help would be…
EverTheLearner
  • 6,550
  • 13
  • 52
  • 71
94
votes
7 answers

Can you use Microsoft Entity Framework with Oracle?

Is it possible to use Microsoft Entity Framework with Oracle database?
Xerx
  • 3,663
  • 7
  • 29
  • 28
38
votes
7 answers

Does ODP.NET require Oracle Client installation

I have to connect Oracle 11g DB from .NET code. For that purpose I installed ODP.NET bur after reading some forum posts I recognized that I need Oracle Client installation too. Is that true? I see that the Oracle Client has a size of ca. 2GB!!! Do I…
llasarov
  • 1,937
  • 5
  • 22
  • 37
38
votes
5 answers

Oracle ODP.net Managed vs Unmanaged Driver

Are there any performance benchmarks between the managed and unmanaged Oracle ODP.Net drivers? (i.e. is there any advantage to moving to the managed driver other than for architectural/deployment simplicity)
John Fedak
  • 421
  • 1
  • 4
  • 7
37
votes
4 answers

What is the minimal setup required to deploy a .NET application with Oracle client 11?

What is the minimal setup required to be able to deploy a .NET application that talks to an Oracle database?
Josh Kodroff
  • 25,181
  • 26
  • 90
  • 147
34
votes
2 answers

Deploying and Configuring ODP.NET to work without installation with Entity Framework

How do you deploy and configure ODP.NET to work without installation with Entity Framework? A. How to deploy and configure Oracle.DataAccess.Client? B. How to deploy and configure Oracle.ManagedDataAccess.Client? C. What do you need to do in order…
Danny Varod
  • 15,783
  • 5
  • 58
  • 98
31
votes
6 answers

Could not load file or assembly Oracle.DataAccess

I have an asp.net mvc (EF) project , I had downloaded oracle data provider with version 4.112.2.50 -32bit on my pc when moving project to windows server 2008 (I have the same version of odp-64bit) I have the below problem: Could not load file or…
user975260
  • 315
  • 1
  • 4
  • 6
31
votes
13 answers

How to write a .Net application that works with both SqlServer and Oracle (now that System.Data.OracleClient is deprecated)

see also System.Data.OracleClient namespace discontinued? (Firstly don’t panic yet, System.Data.OracleClient is not being removed by Microsoft yet, however it is not in the client version of .net 4) This use to be possible by using…
Ian Ringrose
  • 49,271
  • 50
  • 203
  • 302
25
votes
6 answers

ODP.NET Oracle.ManagedDataAcess random ORA-12570 errors

I'm trying to migrate to Oracle.ManagedDataAcess from unmanaged version and receiving randoms ORA-12570 TNS:packet reader failure. I don't know why this error starts, but once it starts, every subsequent request gives the same error for about 10-30…
Edgar Carvalho
  • 976
  • 1
  • 12
  • 23
24
votes
7 answers

ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g server, using version 10.1.0.301 of the ODAC/ODP.Net drivers. After a long period of inactivity (a few hours), the application, seemingly…
Greg Hurlman
  • 17,247
  • 6
  • 50
  • 84
23
votes
6 answers

Oracle.ManagedDataAccess.EntityFramework - ORA-01918: user 'dbo' does not exist

I am trying to implemente code First Migrations with Oracle.ManagedDataAccess 6.121.1.0 provider, but with no success at all. As I am receiving a ORA-code, I am assuming that the connection are been opened successfully. But the Migrations are…
Thiago Lunardi
  • 649
  • 1
  • 4
  • 19
22
votes
2 answers

In WiX how do I test for the existence of a registry key (not value) for Oracle ODP.Net

More specifically I want to test whether Oracle ODP.Net is installed on a machine. I want to do this by testing for the HKLM\SOFTWARE\ORACLE\ODP.NET registry key. The actual values used by ODP.Net are stored in…
Dan
  • 6,650
  • 6
  • 29
  • 41
21
votes
7 answers

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

I have developed an application that uses Oracle Data Provider for .NET. I copy the application file (.exe) and ODP library (Oracle.DataAccess.dll) on another computer that Oracle client and ODP.NET are NOT installed on. When I run the application,…
Sambath Prum
  • 1,748
  • 8
  • 24
  • 33
21
votes
2 answers

Randomly getting ORA-08177 with only one active session

I'm running a program that creates a table and then inserts some data. This is the only program that accesses the database. I'm getting ORA-08177 randomly. Actual code is somewhat complex, but I've written a simple program that reproduces this…
Denis K
  • 1,328
  • 1
  • 9
  • 15
18
votes
2 answers

How does fetching data from SQL Server to SqlDataReader work?

When I call this code: using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand("SELECT * FROM Table", connection); connection.Open(); using (var reader = command.ExecuteReader()) { …
Ladislav Mrnka
  • 349,807
  • 56
  • 643
  • 654
1
2 3
…
86 87