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

1322 questions
6
votes
4 answers

ODP.NET for both 32bit and 64bit

I am developing application which uses ODP.NET to connect to Oracle DB. I would like to have one version for both 32bit and 64bit machines. The problem is that I couldn't figure out how to build projetc with anycpu target, seems it requires the…
NDeveloper
  • 1,837
  • 4
  • 20
  • 34
6
votes
5 answers

Transaction Scope fails with BeginTransaction in Oracle : Connection is already part of a local or a distributed transaction

Having this strange behavior while using OracleConnection with TransactionScope. If i try to use connection.BeginTransaction() in a transaction scope i get simple elegant InvalidOperationException : Connection is already part of a local or a…
adt
  • 4,320
  • 5
  • 35
  • 54
6
votes
1 answer

How to call an Oracle function with a Ref Cursor as Out-parameter from C#?

I'm using a product that provides a database API based on Oracle functions and I'm able to call functions via ODP.NET in general. However, I can't figure out, how to call a function that includes a Ref Cursor as Out-parameter. All the samples I…
Martin Klinke
  • 7,294
  • 5
  • 42
  • 64
6
votes
3 answers

Enable ODP.Net logging

Can anyone help me with enabling ODP.Net logging on a Windows XP machine? I googled and found following link but it did not work for me. http://download.oracle.com/docs/html/E10927_01/featConfig.htm I set the "TraceLevel" setting to "63" in registry…
Viren Jhala
  • 61
  • 1
  • 2
6
votes
6 answers

Some data changes in the database. How can I trigger some C# code doing some work upon these changes?

Suppose I have some application A with a database. Now I want to add another application B, which should keep track of the database changes of application A. Application B should do some calculations, when data has changed. There is no direct…
Theo Lenndorff
  • 4,556
  • 3
  • 28
  • 43
6
votes
1 answer

Updating Oracle 12.1 to 12.2 Oracle Dependency Error occurs

We have recently been struggling to update our C# applications with the new Oracle DLLs. We create our software for multiple platforms. So our software solution is both a winform desktop application and a ASP.NET MVC webapplication. Both…
Leroy Meijer
  • 1,169
  • 17
  • 40
6
votes
1 answer

How can I get unmanaged ODP.NET (64-bit) working in ASP.NET on 64-bit O/S?

I have to get a legacy application that uses unmanaged ODP.NET working on a 64-bit machine. I have installed 64-bit unmanaged ODP.NET I have verified that the 64-bit unmanaged ODP.NET is working fine by testing it in a console application I…
Zesty
  • 2,922
  • 9
  • 38
  • 69
6
votes
2 answers

ODP.NET Connection request timed out

I have a web application hosted on IIS 7, using Oracle.DataAcess.dll for .NET to perform the connection and queries to the Oracle Data base. In the last week, we suddenly encountered numerous errors thrown by this component, saying: "Connection…
Amit Ben Ami
  • 548
  • 2
  • 6
  • 21
6
votes
2 answers

Does ODP.net close a ref cursor when the connection closes?

I haven't been able to find this explicitly stated anywhere yet, but a bunch of examples I've found online follow what I've been doing. I have a C# class which uses ODP.net to connect to an Oracle DB and run a procedure that's in a package. My…
Dave Baghdanov
  • 2,288
  • 5
  • 24
  • 35
6
votes
1 answer

How to disable connection pool?

Connection string that my app is using to connect to DB is the following: private const string oradb = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=host.name)(PORT=1521)))" +…
Pablo
  • 28,133
  • 34
  • 125
  • 215
6
votes
1 answer

Error 2002 : The EntityContainer 'X' for the storage model specified as part of this MSL does not exist in MetadataWorkspace

I'm trying to integrate my Oracle Database into my ASP.NET app, but I keep getting this error : Error 2002: The EntityContainer 'OracleDBTargetContainer' for the storage model specified as part of this MSL does not exist in …
JuFra
  • 173
  • 3
  • 11
6
votes
3 answers

Oracle Entity Framework - Call custom function (EDIT_DISTANCE)

I am using Entity Framework 6 and Oracle Database 11g (ODP.NET Manage Driver). How to call UTL_MATCH.EDIT_DISTANCE function in LINQ query?
Dolfik
  • 83
  • 1
  • 2
  • 5
6
votes
7 answers

Visual Studio ODP Unmanaged Driver - Failed to find the default tnsnames.ora file (12c )

I'm developing an app in Visual Studio 2013 that connects to a Oracle Database. I have to use the "Unmanaged Driver". When I'm trying to create a new connection in a dataset, when I chose the "Managed Driver" all work fine: the tnsnames.ora is…
tapatio
  • 387
  • 1
  • 4
  • 9
6
votes
1 answer

Oracle.ManagedDataAccess Connection request timed out

I'm having trouble with threaded code which I'm using with the Oracle ManagedDataAccess.dll. To simulate the issue I have created a small test application that opens a connection, does a query and closes the connection. The thing that happens is…
Vincent
  • 61
  • 1
  • 1
  • 4
6
votes
2 answers

Having two ODP.NET (ODAC) versions in the same server

Some months ago, a colleague of mine installed ODAC 11.106.21 in a server using XCOPY and then he developed many applications that use this client without problems (in test and production windows servers). Past week, I developed an application under…
vizcayno
  • 1,223
  • 3
  • 16
  • 24
1 2 3
…
88 89