Stack Overflow
Stack Overflow

Questions tagged [odac]

Oracle Data Access Components are data access drivers and tools for Windows.

246 questions
3
votes
1 answer

Error PRVF-7536 Installing Oracle ODAC 12c Release 4 (12.1.0.2.4)

I'm trying to install the Oracle ODAC 12c Release 4 (12.1.0.2.4) on my Windows 10 Pro x64 machine but I'm facing a very weird error in the "Perform Prerequisites Checks" step, AFAIK the error is telling me I'm using the wrong package for my…
Anon Dev
  • 1,361
  • 3
  • 14
  • 29
3
votes
1 answer

Oracle in C#, bind variables, and queries like ID IN (1, 2, 3)

I'm looking for a C# ODAC adaptation of the following Java technique, where code is able to bind an array of numbers (the array size can vary) into a non-PL/SQL SELECT statement and then use the resulting array in a WHERE ID IN (...) style…
StilesCrisis
  • 15,972
  • 4
  • 39
  • 62
3
votes
2 answers

EntityFramework 6 with Oracle: Is there a "standalone" ODAC (i.e. without ODBC), and does every client PC need to have it installed?

While my VS 2013 Update 4 installation is running I decided to ask some questions that are bothering me and which are potentially easy to answer as I couldn't test myself yet (due to having had an older VS version up until now). Also, I don't have…
InvisiblePanda
  • 1,589
  • 2
  • 16
  • 39
3
votes
3 answers

Entity Framework wildcards & Linq

Is it possible to construct a valid Linq query which contains wildcard characters? I've seen various answers to this question which suggest using: .Where(entity => entity.Name.Contains("FooBar")) .Where(entity => entity.Name.EndsWith("Bar"))…
philreed
  • 2,497
  • 5
  • 26
  • 55
3
votes
4 answers

Getting "cannot insert NULL into ("schema"."table"."column") when column is not null

Whenever I try to create a new myObj in mySchema, it keeps telling me that ID is null, but when I run the debugger, the debugger tells me the object I'm adding has no NULL values. It works on my colleague's machine, but not on mine... MyObj myObj =…
Bob.
  • 3,894
  • 4
  • 44
  • 76
3
votes
1 answer

Can I use 32 bit Oracle Developer Tools with x64 ODAC in VS2010?

From the Oracle website here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html This is for their latest Oracle Data Access Components, 64-bit ODAC 11.2 Release 4 (11.2.0.3.0) for Windows x64. I want to use the…
DaveN59
  • 3,638
  • 8
  • 39
  • 51
2
votes
1 answer

Oracle Data Access components 64 bit not working in IIS express 7.5

I have installed ODAC (Oracle data Access Components 64 bit) odp.net 4. But unfortunately it does not work with IIs Express. IIS express documentation says it supports both 32bit and 64bit systems. Is it possible that it can work with odp.net 4 (64…
iknowitwasyoufredo
  • 605
  • 1
  • 10
  • 19
2
votes
1 answer

(ORA-12154) Unable to connect to data source in tnsnames.ora from migrated SSIS project in VS 2017

I have a directive to pull code off of an old server and move it to my workstation, and also to update all TFS connections to our new TFS 2017 setup. I found a very important SSIS project that was only maintained by the person I replaced; it was…
CDove
  • 1,940
  • 10
  • 19
2
votes
1 answer

Entity Data Model Wizard Gets Exception When Trying to Add a New Oracle Connection

I'm trying to generate/update an edmx model from an oracle database and I need to create a new connection to that oracle database. When I click "Test Connection" it succeeds but when I click "OK" it gives the following error: Operation is not valid…
Silmarie
  • 21
  • 3
2
votes
1 answer

Delay / Lag between Commit and select with Distributed Transactions when two connections are enlisted to the transaction in Oracle with ODAC

We have our application calling to two Oracle databases using two connections (which are kept open through out the application). For certain functionality, we use distributed transactions. We have Enlist=false in the connection string and manually…
Chathuranga Wijeratna
  • 891
  • 6
  • 17
2
votes
1 answer

Get Multiset field value of Oracle Query on Delphi with ODAC

Hellо! I want to get Multiset field value of Oracle Query on Delphi 7. For example on Delphi: QSQl.SQL.Text := "select cast (multiset (select id, summa from temp) as nach_table) t from dual"; I wrote this code: temp: TOraNestTable; ... temp := …
Fantomas
  • 1,495
  • 4
  • 12
  • 21
2
votes
0 answers

Oracle and vnext ASP.NET 5

Is the Oracle Data Provider ODAC compatible with ASP.NET 5 (vnext)? All of the documentation I found shows compatibility up to ASP.NET 4.6.
Vix
  • 21
  • 3
2
votes
1 answer

ODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger

I am new to Oracle, and there is an issue I am facing. When I run the application from IDE - Visual Studio 2005, The database connection is established smoothly, but when I run an installed version of the app, the DB connection fails and I get a…
Sreedevi J
  • 673
  • 1
  • 9
  • 15
2
votes
1 answer

Adding dll to release

We have completed development of our first big application in C# and we need to export it. Our app should work by just opening the .exe file. There may be some other files in Source folder, it does not matter(dll can be next to .exe). We released…
Daniel Švarc
  • 59
  • 1
  • 9
2
votes
0 answers

Why does ODAC Connection.open() sometimes raise an OracleException?

I catch an exception with empty message just at Connection.Open() line. the error code:-2147467259 the stack trace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*…
Masoud Sedghi
  • 495
  • 1
  • 6
  • 19
1 2
3
…
16 17