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
18
votes
1 answer

Oracle Connection Pooling in .Net

We have a system that uses an Oracle database. I've been asked if the system makes use of connection pooling which I'm not sure about. We are using the Oracle.DataAccess.Client.OracleConnection When reading up on the subject I've found that…
Steve
  • 2,950
  • 3
  • 21
  • 32
18
votes
4 answers

Connecting to Oracle using Oracle.ManagedDataAccess

I am using Oracle.ManagedDataAccess Nuget Package Version 12.1.022 in my C# (.NET 4.0) project. The package automatically creates entries in the app.config file. How can I read the datasource string from this file to be able to connect to the data…
Khurram Majeed
  • 2,291
  • 8
  • 37
  • 59
17
votes
5 answers

Oracle.ManagedDataAccess OracleInternal.NotificationServices.ONSException

We use the 'Oracle.ManagedDataAccess' ODP.NET driver for database access to Oracle. When connecting to the database with the connection string: Data…
J. Deing
  • 171
  • 1
  • 6
17
votes
2 answers

Usage of Oracle binding variables with LIKE in C#

As part of an effort to stop using dynamic SQL generation and encourage use of bind variables, I am running into some problems. I am querying an Oracle 9i database from an ASP.NET page using Oracle Data Providers for .NET The query is sql = "SELECT…
PJ.
  • 391
  • 1
  • 3
  • 11
16
votes
4 answers

Is it ok to use oracle 11g client with a 10g server?

I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g. I am too late in the development process to make a change. Am I heading for trouble? Have you had any experience running 11g client…
Micah
  • 10,295
  • 13
  • 66
  • 95
16
votes
6 answers

ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file

Overview I want to replace Oracle.DataAccess with Orcale.ManagedDataAccess, but opening a connection with the latter throws an ORA-12537 network session end of file exception. Exception message / stack trace {OracleInternal.Network.NetworkException…
Greg
  • 1,076
  • 1
  • 9
  • 17
16
votes
5 answers

The provider is not compatible with the version of Oracle client error when using Oracle.DataClient

I'm using Visual Studio 2008 Express Edition, and I'm trying my hand in developing a small application using Oracle.DataClient. I'm getting the above mentioned error, when trying to connect to the database in the target system. I've added a…
Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
16
votes
3 answers

Binding query parameters by name with ODP.NET

I'm currently using the Microsoft ADO.NET provider for Oracle (System.Data.OracleClient). I'm aware that it is certainly not the best Oracle provider available and that it will soon be deprecated, I should be using Oracle's ODP.NET instead. The…
Thomas Levesque
  • 286,951
  • 70
  • 623
  • 758
15
votes
2 answers

How to clear the ODP.NET connection pool on connection errors?

I'm using NHibernate and ODP.NET to connect to a Oracle 11g database. Of course there can be connection errors (network failure, DB down, ...). I'm handling all these exceptions in my code, so no problem there. But of course the user can retry his…
cremor
  • 6,669
  • 1
  • 29
  • 72
14
votes
1 answer

Replacing System.Data.OracleClient to Oracle.DataAccess (ODP.NET)

I have a project which is using System.Data.OracleClient at the moment and since it is being deprecated so I want to switch to the ODP.NET latest version for Oracle 11g. Please let me know if the following steps would work for me or there are…
ria
  • 819
  • 5
  • 19
  • 40
14
votes
3 answers

Oracle.DataAccess.Client Dependencies

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…
billybob
  • 2,859
  • 6
  • 35
  • 55
14
votes
3 answers

Code for calling a function in a package from C# and ODP.NET

I've tried to write C# code with ODP.NET to call a function in a package. I'm getting the two errors below: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to INSERT_FUNC' ORA-06550: line 1, column 7: PL/SQL:…
user2776709
  • 401
  • 1
  • 5
  • 8
14
votes
3 answers

ODP.net Oracle Decimal Number precision problem when filling a dataset. Exception: Arithmetic operation resulted in an overflow

I am working in c# .net 2 (Visual Studio 2005 SP1) attempting to fill a dataset with the results from a select * from table from an Oracle10g database. The .net framework, IDE and database cannot be changed at this client site. I'm connecting using…
m3ntat
  • 3,635
  • 11
  • 38
  • 50
13
votes
9 answers

ODP.NET error Unable to find the Requested .Net Framework Data Provider

I am trying to develop an ASP.NET MVC 4.0 application using Oracle 11g Express and the .NET 4.0 framework. I can connect to the DB using the ODP.NET provider and can also generate my EDMX against the database. What I can't do is query the underlying…
Captain Kenpachi
  • 6,960
  • 7
  • 47
  • 68
12
votes
5 answers

Managed ODP.NET driver does not show up in Data Source dialog

Having installed managed ODP.NET on my computer, the ODP.NET Managed Driver does not appear inside the Choose Data Source dialog in Visual Studio 2013 Professional. This is how it should look like: This is how it actually looks on my machine: I've…
Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
1
2
3
…
88 89