Stack Overflow
Stack Overflow

Questions tagged [odac]

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

246 questions
5
votes
12 answers

OracleMTSRecoveryService failed to start?

i am getting this error while starting OracleMTSRecoveryService : Could not start the OracleMTSRecoveryService service on Local Computer. Error 1: Incorrect function.* Also during installation of ODAC service start failed. OracleXETNSListener is…
Talal
  • 131
  • 1
  • 1
  • 13
5
votes
2 answers

How to host an ASP.NET application that uses Oracle 11g on a machine that has only Oracle 12c?

My ASP.NET application runs on a Windows Server 2008 R2 server. Oracle 11g is installed. I deployed this application to a Windows Server 2016 server. Oracle 12c is installed in this server (11g is not supported). When I run the application, I get…
Ned
  • 1,055
  • 9
  • 34
  • 58
5
votes
1 answer

Unable to install Oracle Developer Tools for Visual Studio

I have already installed Visual Studio 2015 and also installed Oracle12c latest version database and I'm trying to install Oracle Developer Tools for Visual Studio but it is showing the following error: On clicking next button it is showing the…
SuRu
  • 739
  • 1
  • 6
  • 19
5
votes
1 answer

Multiple 'Or' statements in EF expression

Given a list of filter parameters in the form of: public class filterParm { public int age { get; set; } public string name { get; set; } } Where: var parms = new List { new filterParm {age = 22, "phil"}, new filterParm…
philreed
  • 2,497
  • 5
  • 26
  • 55
5
votes
3 answers

ORA-00932: inconsistent datatypes: expected DATE got NUMBER

I am using Oracle Data Access from .net and my query is as command.CommandText = "select * from table1 where expirydate =:EXPIRYDATE"; command.Parameters.Add("EXPIRYDATE", OracleDbType.Date, DateTime.Today,ParameterDirection.Input); var results =…
MicroMan
  • 1,988
  • 4
  • 32
  • 58
5
votes
1 answer

System.Reflection.RuntimeModule.GetTypes() error with ODP.Net and C#

I wrote a fairly complex C# application which accesses an oracle database via ODP.Net. I developed the application on a windows XP machine (32-bit) where I installed ODAC (32-bit). The application runs without a glitch on my development PC but…
edd
  • 933
  • 2
  • 11
  • 24
4
votes
1 answer

Understanding Oracle database and ODAC installation

I want to use Oracle XE DB in my ASP.NET MVC project. I installed Oracle 11g XE on same machine where is VS running. Installation completed succesfully in C:\oraclexe. Everything as expected, i was able to connect to DB via Server Explorer using…
sanjuro
  • 1,611
  • 1
  • 21
  • 29
4
votes
1 answer

Oracle.DataAccess.Dll x64 support

My oracle.dataaccess.dll is not supported on x64 machines. I've looked for it everywhere - but all I could find is the x86 version. Anyone knows where can I get it from?
Nissim
  • 6,395
  • 5
  • 49
  • 74
4
votes
4 answers

ROWNUM returns as "invalid identifier"

I am running a very basic select against an oracle database (not sure of the version). SELECT * FROM ACCOUNTING WHERE ID = 123456 ORDER BY DATE I want to return only the most recent record. So I have tried ... SELECT ROWNUM, * FROM ACCOUNTING WHERE…
Gary O. Stenstrom
  • 2,284
  • 9
  • 38
  • 59
4
votes
1 answer

Does ODP.NET support EF Model-First with DbContext?

We're trying to use an Entity Framework Model-First approach with Oracle 11g and ODP.NET 11.2.0.3.20. We'd like to use EF 4.1 or EF 5.0 with DbContext. Short version: Has anyone managed to do that? Long version: On VS2010 and Entity Framework 4.0,…
Jonas Sourlier
  • 13,684
  • 16
  • 77
  • 148
4
votes
3 answers

ORA-24338: Statement handle not executed

i'm using Delphi 7, Oracle 10, and ODAC Components. From the LoadTrainResult method I'm calling a storedProc. procedure TfrmTrain.LoadTrainResult; begin StoredProc.StoredProcName := 'PTRAIN.QTRAIN'; …
user1469630
  • 191
  • 3
  • 5
  • 15
3
votes
1 answer

ODAC for Entity Framework outputting malformed SQL?

I've been migrating a system from MS SQL to Oracle and have been more or less without difficult snags until running into this issue. The error message I wind up getting from oracle is: ORA-06550: line 4, column 54: PL/SQL: ORA-00926: missing VALUES…
chrispy
  • 88
  • 1
  • 5
3
votes
0 answers

c++ builder devart odac

I am using the ODAC components designed by the devart company with embarcadero C++ builder 10.2. Now I want to define an own class, which should be able to establish a connection to an oracle database. So I want to use the TOraSession component…
Hoeh
  • 45
  • 4
3
votes
0 answers

Oracle CommandTimeout does not work. Hangs on table lock until lock is released

In my .Net application I'm experiencing issue with Oracle CommandTimeout. When I querying to the locked table using text command without bound parameters CommandTimeout fires fine as expected. But If I introduce and bind any parameter to the command…
Yauhen K
  • 31
  • 2
3
votes
1 answer

SSL/wallet error trying to access Oracle DB from SSRS

I'm trying to access a third party Oracle database from SQL Server Reporting Services. I had it working on previous versions of SQL Server and Oracle ODAC, but it's been several years. I'm now being forced into an upgrade, and when I try to create…
user1013571
  • 125
  • 1
  • 7
1
2
3
…
16 17