Stack Overflow
Stack Overflow

Questions tagged [odp.net-managed]

The Oracle Managed DataAccess Provider is the .Net Native version of ODP.Net. It doesn't need a prior Oracle Client installation or have any dependency on the OCI library. Applications that reference it may therefore be built 'AnyCPU'.

110 questions
0
votes
1 answer

How to run odp.net application in both .net 3.5 and .net 4

I am working on an internal tool for our product. Our product uses oracle database and have evolved over time from .net framework 2.0 to 4.5 and Oracle 10 to 12.2. The aim of the tool is to write a single application which works across different…
Satish
  • 445
  • 2
  • 4
  • 15
0
votes
0 answers

DbContext keeps throwing "The context cannot be used while the model is being created." error after exception

I have a new application I'm developing that is using Entity Framework 6, ODP.NET, Oracle Managed Driver for Entity Framework and an Oracle database. What I'm seeing is that if an exception is thrown while DbContext is in use, it appears it doesn't…
Josh
  • 8,219
  • 13
  • 76
  • 123
0
votes
1 answer

ODP.NET Managed Data Access LDAP Configuration not working unless LDAP.ORA is included

For some reason I have to include an LDAP.ORA file inside my .NET project when attempting to connect to Oracle with LDAP. From my understanding of using the Oracle.ManagagedDataAccess nuget package I should be able to contain everything within the…
Blake Blackwell
  • 7,575
  • 10
  • 50
  • 67
0
votes
0 answers

System Oracle -> Oracle Managed

I swapped out the references but I am getting an error that it can't cast System.Oracle to Oracle.ManagedDataAccess public static DataSet ExecuteDataSetWithTimeOut(string spName, object[] parameterValues) { OracleCommand cmd = new…
carpeltunnel
  • 11
  • 4
0
votes
1 answer

Call to UTL_I18N.string_to_raw via ODP.Net Managed Provider results in a lossy character set conversion exception being thrown

I'm trying to store encrypted unicode text in an Oracle RAW field. Before encryption I'm converting the string to a raw byte array as AL32UTF8, for the sake of efficiency. (NLS_NCHAR_CHARACTERSET is AL16UTF16). A LOSSY_CHARACTERSET_CONVERSION…
dipdapdop
  • 126
  • 1
  • 10
0
votes
1 answer

ODP.NET - disable auto commit

Is there a simple way how to disable auto commit when using ODP.NET? I want to start transactions using SET TRANSACTION command, not using Connection.BeginTransaction neither TransactionScope. Also I want to any DML start transaction (if not started…
Husqvik
  • 5,669
  • 1
  • 19
  • 29
0
votes
1 answer

ODP.Net Managed Driver Ignoring Transaction Rollback

I'm replacing our older unmanaged ODP driver with Oracle's managed driver, and I'm discovering that my transactions are committing even if rolled back explicitly or not committed. var conn = new OracleConnection(...); conn.Open(); var trans =…
Grant H.
  • 3,689
  • 2
  • 35
  • 53
0
votes
2 answers

Expression Tree for .NET DateTime <> Oracle Timestamp like search

I need to know whether I can get a clue or not. I am trying to build an Expression Tree that is evaluated via Entity Framework 6 (LINQ to Entities) via ODP.NET managed driver (current Version) to the appropriate Oracle statement in order to perform…
Orca11
  • 3
  • 2
0
votes
0 answers

.net web service Oracle database connection issue

I have a .net web service I have inherited (asmx). Everything is fine, until the database goes down for maintenance. Once this happens, the web service can't connect to the Oracle 11g database until the app pool is recycled. The web service uses…
frmrock164
  • 47
  • 11
0
votes
2 answers

ODP.NET Managed library does resolve alias, but 32-bit library does

I have 32-bit drivers installed on my box (they were installed and configured by some DBAs) I wrote a simple script to test the drivers which pretty much is as follows using (DataTable table = new DataTable()) { using (OracleConnection…
Brad Zacher
  • 2,915
  • 18
  • 31
0
votes
1 answer

Oracle managed driver can't resolve TNS name, yet exists in trace

I've installed and configured the Oracle.ManagedDataAccess client with the correct TNS_ADMIN setting (in .NET config file). When I enable Oracle tracing, it correctly picks up the TNS_ADMIN setting and even lists all of the TNS entries from…
Vince Fedorchak
  • 155
  • 1
  • 2
  • 10
0
votes
0 answers

ODP.Net and create database notification

i am using ODP.net (or rather Oracle.ManagedDataAccess.dll) to create change notification. It works fine, however I have one problem. It occurs when Windows is starting. Sometimes my application starts before "something oracle proccess" and creating…
templaris
  • 221
  • 5
  • 11
0
votes
1 answer

Where to store ODP.NET Managed Driver Connection Strings?

Finally got ODP.NET configured and the Oracle.ManagedDataAccess DLL referenced in the project. I was testing with a TNS connection in the code behind in a WPF project (see below). This question is probably elementary, but I can't find any good…
user17753
  • 3,083
  • 9
  • 35
  • 73
0
votes
1 answer

InvalidCastException when running a query that returns a number

I have a query... select real_arrival_date-planned_delivery_date as days_late from ifsapp.purchase_receipt_statistics where real_arrival_date and planned_arrival_date are columns of type date. The resulting days_late will be a decimal number…
mason
  • 31,774
  • 10
  • 77
  • 121
0
votes
2 answers

Unable to connect through ODP Managed driver

I have a windows forms app, in which I am trying to connect to Oracle 11g DB with OracleManaged driver, which ends with an exception "ORA-12154: TNS:could not resolve the connect identifier specified". However when I am trying to connect through…
Krishna Sarma
  • 1,852
  • 2
  • 29
  • 52
1 2 3 4 5 6
7
8