Stack Overflow
Stack Overflow

Questions tagged [odac]

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

246 questions
38
votes
8 answers

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to use ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework…
Wasef Anabtawi
  • 1,011
  • 1
  • 10
  • 17
24
votes
4 answers

How can I deploy a .NET application that uses ODAC without installing the whole component to the user?

I have written a C# application that connects to an Oracle 10g database. Using Oracle Data Access Component 11.2 "ODAC", it works perfectly on my machine. And now I want to deploy the application and install it in another "clean machine" that has…
3oon
  • 365
  • 1
  • 5
  • 15
13
votes
4 answers

ODAC 12c and Entity Framework 6

Can anyone tell me if the Oracle Data Access Components 12c is compatible with Entity Framework 6? The Oracle website is a nightmare for documentation and cannot find any references on how to resolve this. I have an existing project which I am…
philreed
  • 2,497
  • 5
  • 26
  • 55
12
votes
2 answers

Get value of Oracle OUT parameter from a stored procedure call using Dapper.NET

Edit: Using the Execute method instead of the Query/QueryMultiple methods, my OUT_SUCCESS parameter now has an AttachedParam with with an OracleParameter that has the returned value. So this would work if, for instance, I only needed to retrieve…
tacos_tacos_tacos
  • 10,277
  • 11
  • 73
  • 126
9
votes
3 answers

ODAC 11.2 Release 4 (11.2.0.3.0) throwing "Oracle 11.2.0.2.0 does not support APPLY" exception

I'm using Entity Framework with the new ODAC that oracle just released. My problem is that some of my queries that were working in previous beta releases stopped working in this new release version. Here's an example: IQueryable query1 =…
Pedro Fonseca
  • 449
  • 5
  • 10
9
votes
5 answers

Entity Framework 6 (5) connection to Oracle

I am attempting to write a Data Access library for our suite of applications that use Oracle in .net. We currently use NHibernate and are thinking of migrating away as it appears to not be supported all that well. I am working with Visual Studio…
SoftwareSavant
  • 9,467
  • 27
  • 121
  • 195
8
votes
4 answers

Oracle Instant Client and Entity Framework trouble with configuration

I'm trying to learn and figure out if it is possible to deploy an MVC, EF, ODAC 11.2.0.3 app to a server that has a previous version of ODP.NET installed. Rather than updating the sever ODP.NET (which I can't), I figured I could use the Oracle…
Mustang31
  • 282
  • 1
  • 3
  • 15
7
votes
3 answers

ODAC: Object reference not set to an instance of an object

I am trying to connect to Oracle Express 11g. I am using ODAC 12c with Visual Studio 2015. Here's how I am trying to connect: OracleConnection con; con = new OracleConnection("User Id=SYSTEM;Password=manager;Data Source=(DESCRIPTION = (ADDRESS =…
Nikita Zernov
  • 5,465
  • 6
  • 39
  • 70
7
votes
2 answers

Difference between Oracle Client and ODAC

What is the difference between installing the full Oracle Client and an Oracle Odac install? Which will I need to do .NET development on my dev workstation and which will I need on the web application server that will connect with the Oracle…
Vince Miccio
  • 113
  • 1
  • 1
  • 6
7
votes
1 answer

Using Oracles ODP.NET 12c Release 2 with Oracle 11g r2 Database

Our Oracle Db's are Oracle 11G r2,. We use Visual Studio 2013 for development. Is ODAC 12C backwards compatible with the Oracle 11g r2 server? Are there any issues a developer will encounter using a newer ODAC /ODP.NET version than the database it's…
Ryan Ternier
  • 8,714
  • 4
  • 46
  • 69
7
votes
0 answers

Error 0152: No Entity Framework provider found for 'Oracle.DataAccess.Client' ADO.NET provider

I have Windows 7 x64, Visual Studio 2012 with the 'ODAC 11.2 Release 5 and Oracle Developer Tools for Visual Studio (11.2.0.3.20)'. Then I connected to Oracle db, create .edmx model. But when I'm trying to use EF to operate some data var ent = new…
Aleksei Zaitsev
  • 182
  • 2
  • 10
6
votes
1 answer

ODP Oracle.DataAccess.DLL reference 32/64 bit

I have a .NET 3.5 assembly that references ODP (Oracle.DataAccess.dll), building in Visual Studio 2010. Copy Local = False, Specific Version is false. The path is C:\[ORACLE_BASE]\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll The…
Stealth Rabbi
  • 10,156
  • 22
  • 100
  • 176
6
votes
2 answers

Oracle OLE DB Provider not Listed in SSIS

I'm having an issue with SSIS and VS2015 CM. I have a package that needs to connect with Oracle to get some data. I installed the ODAC for Win64 and the Oracle client but I can't see the Oracle provider for OLE DB listed in the providers list.…
MagdielAybar
  • 187
  • 1
  • 2
  • 12
6
votes
1 answer

How do I fix problems when importing an Oracle database into an Entity Framework model using ODAC 12c Release 4 and EF 6?

I'm trying to import tables and views from an Oracle database using ODAC 12c Release 4 and Visual Studio 2015 with EF 6 into an .edmx model. I can import most tables and views just fine, but some of them contains errors and I can't figure out how…
Telorast
  • 61
  • 5
5
votes
1 answer

Oracle SqlError: Protocol Violation / OALL8 is in an inconsistant state

I'm getting Protocol Violation and OALL8 is an inconsistant state exceptions trying to execute SELECT queries, but only on SOME of my tables. I first noticed this in a test application that I wrote that did a SELECT * FROM SOMETABLE. It would get…
Stealth Rabbi
  • 10,156
  • 22
  • 100
  • 176
1
2 3
…
16 17