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
8
votes
2 answers

Problem on using ODP.Net

I've successfully used Oracle Database 11g Release 2 (11.2.0.1.0) to connect oracle from .Net. (in reference Oracle.DataAccess.dll version was 2.112.1.0). But when I installed ODP.NET and when I am trying to connect to oracle, it gives me an error:…
Vano Maisuradze
  • 5,829
  • 6
  • 45
  • 73
8
votes
5 answers

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I'm trying to connect my local Oracle 11g database using server explorer in Visual Studio 2010. I tried to setup everything as per instruction, but I'm still getting an ORA-12504 error. Here is the error: Here is my tnsnames.ora contents: #…
Ris
  • 1,152
  • 7
  • 29
  • 63
8
votes
1 answer

ODP.net pass UDT as table to a stored procedure in C#

I have a custom Type which looks like this create or replace TYPE order_type AS OBJECT ( order_type VARCHAR2 (50), quantity VARCHAR2 (50), price NUMBER, ); Table defined as below create or replace TYPE order_tabtype AS TABLE OF…
Praneeth
  • 2,527
  • 5
  • 30
  • 47
8
votes
3 answers

ODP.NET Connection exception

First I would like to say that I am not familiar at all with Oracle databases, so my words might be poorly chosen and my understanding of some concept might be wrong... Anyway, I am trying to connect to an Oracle 11g database using ODP.NET and…
Simon ML
  • 1,819
  • 2
  • 14
  • 32
8
votes
7 answers

Is there a way to force OracleCommand.BindByName to be true by default for ODP.NET?

Since the System.Data.OracleClient library has been deprecated, we are in the process of migrating our code base to use Oracle Data Provider for .NET (ODP.NET) instead. One of the issues that we have encountered is that the System.Data.OracleClient…
rjzii
  • 14,236
  • 12
  • 79
  • 119
8
votes
6 answers

How to determine which version of "Oracle.DataAccess.dll" to include

While deploying my .NET 3.5 Windows form to different environments we ran with lots of invalid provider issues. It works on some and doesn't work on others. Could someone please help me out, how do I determine which version of…
Nil Pun
  • 17,035
  • 39
  • 172
  • 294
8
votes
5 answers

Error using oracle.dataaccess.dll

I have a web application which uses Oracle.DataAccess.dll to communicate with an Oracle db. The web application deployed on 32 bit windows system works but not on windows server 2008 64 bit. I installed 10204_vista_win2k8_x64_production_db package,…
Zoliqa
  • 1,015
  • 2
  • 15
  • 36
8
votes
4 answers

Unable to find the requested .Net Framework Data Provider in Oracle

string constr = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spp01)(PORT=1521))(CONNECT_DATA=(SID=Global)));User Id=SYSMAN;Password=testman3"; string ProviderName = "Oracle.DataAccess.Client"; DbProviderFactory factory…
Ranjith kumar
  • 223
  • 2
  • 6
  • 11
8
votes
2 answers

Timeout for OracleDataReader.Read Method

The ODP.NET OracleCommand class has a CommandTimeout property that can be used to enforce a timeout for the execution of a command. This property seems to work in situations where the CommandText is a SQL statement. The example code is used to…
dnickels
  • 833
  • 1
  • 9
  • 21
8
votes
4 answers

ODP.NET Connection Pooling Parameters

I am trying to configure connection pooling for my .NET application using ODP.NET version 2.111.6.20. The database is Oracle 11.1. I am using the following connection string in my .NET 2.0 application: Data Source=prod; User Id=FAKE_USER;…
jprincipe
  • 241
  • 1
  • 2
  • 8
8
votes
4 answers

LINQ to SQL for Oracle.ODP

Does LINQ to SQL support Oracle.ODP? If not, is a similar offering from Oracle available or in the works?
LBushkin
  • 129,300
  • 32
  • 216
  • 265
8
votes
4 answers

Oracle Managed ODP.NET can't find tnsnames.ora

My managed ODP.net webapp works locally but when deploying it to a server, it fails with the error: "TNS:listener does not currently know of service requested in connect descriptor" From looking around, it seems like this is because it can't get to…
SeanKilleen
  • 8,809
  • 17
  • 80
  • 133
8
votes
3 answers

Whatis is best approach on executing multiple UPDATE statement in one connection?

How to properly do the following update: using (OracleConnection conn = new OracleConnection()) using (selCmd) { string sql1 = "update Table1 set name = joe where id = 10;" string sql2 = "update Table2 set country = usa where region =…
ombinar
  • 241
  • 2
  • 4
  • 11
8
votes
6 answers

Is ODP.NET required for Oracle 11g Client?

I may be asking the wrong question here, I'm willing to change it if so. I have a project that is using the Microsoft.NET Oracle provider (our plan is to change to ODP but we haven't done so yet). I am trying to get this project to build on a…
Jeff Martin
  • 10,812
  • 7
  • 48
  • 74
8
votes
4 answers

ORA-01460: unimplemented or unreasonable conversion requested

When I run the following .Net code: using (var c = Shared.DataSources.BSS1.CreateCommand()) { c.CommandText = "\r\nSelect c1, c2, c3, rowid \r\nFrom someSpecificTable \r\nWhere c3 = :p0"; var p = c.CreateParameter() as…
Noam
  • 4,472
  • 5
  • 30
  • 47
1 2 3
…
88 89