Stack Overflow
Stack Overflow

Questions tagged [odac]

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

246 questions
1
vote
2 answers

Powershell 5.1 using Oracle Data Provider for .NET, query result not in table

I'm trying to query a test database, while I am using SQLdeveloper SELECT * FROM TESTABLE The result show my table as USER_ID USERNAME ---------- -------------------- 1001 user1 1002…
Alex You
  • 13
  • 4
1
vote
1 answer

Invalid casting error when recurring division result is read using OracleDataReader

OracleDataReader is throwing an error when the recursive division(say 1/3) result is returned. No error if the divisions are non-recursive(say 1/2). The error message is "Specified cast is not valid." The code snippet is as follows string…
Baji Jabbar
  • 167
  • 1
  • 10
1
vote
1 answer

InstallAllOracleASPNETProviders doesn't work correctly

I am using asp.net mvc 3 and oracle database with ODAC1120240Beta_EntityFramework. I want to do authorization in my site. Database works correctly, I can do everything with Database data, but if I go to ASP.NET Configuration -> Provider I see only…
DraggonZ
  • 11
  • 4
1
vote
1 answer

Oracle.ManagedDataAccess.Client with Proxy User has error ORA-01017: invalid username/password; logon denied

I have a project which connects (just fine) to Oracle via ODAC, Oracle.DataAccess.Client in .NET. I would like to switch it to use Oracle.ManagedDataAccess.Client, but it gives an error ORA-01017: invalid username/password; logon denied. I know…
tgolisch
  • 6,549
  • 3
  • 24
  • 42
1
vote
2 answers

define database schema name universally in entity framework 4.1

i know you can define the entity's schema name per class by using ToTable("TableName", "SchemaName") but is there a way to set it up so you can set the schema name for all tables in the configuration as i am getting some weird results when i am…
Chris McGrath
  • 1,727
  • 3
  • 19
  • 45
1
vote
2 answers

Can the ODP.NET Managed Driver and Unmanaged Driver be run in parallel on the same machine

I need to install and run a legacy piece of software (circa 2014) implementation utilising the unmanaged driver from ODP.NET, unfortunately corporate software has been updated, replacing the unmanaged driver with the managed driver. Is it possible…
Paul Johnson
  • 213
  • 3
  • 14
1
vote
2 answers

C# Oracle Connection without Client // missing dll

I'm trying to connect with Visual Studio 2019 and C# to Oracle without OracleClient. I downloaded the ODAC xcopy 32 bit and copied to the debug folder. After that, I referenced the Oracle.DataAccess.dll. When I tried to run the Application at…
Tobias
  • 41
  • 8
1
vote
2 answers

Entity Framework is not generating entity classes

Entity Framework: 6.4 Oracle Managed Data Access: 19.7 Oracle Managed Data Access Entity Framework: 19.7 Visual Studio: 2019 Oracle database: 11g Entity Framework Wizard is working without any problems, but after I click finish, after a couple of…
Savo Pejović
  • 133
  • 1
  • 9
1
vote
1 answer

Error: The spawned process exited with non-zero exit code

I am trying to install ODTwithODAC "Oracle Universal installer with Odac" for visual studio,so i could connect Oracle database with C# and i am getting this error: "The spawned process exited with non-zero exit code!!". then the installation is not…
Tarek
  • 11
  • 1
  • 4
1
vote
0 answers

Oracle Alter User Not Working With PowerShell

I am trying to use PowerShell to change Oracle accounts. The .net DLL does not seem to support Oracle SQL that contains Alter User command. I am getting the following output/error: Trying to connect to Database instance on NIMHDDEV...Success. SELECT…
Barry MSIH
  • 3,525
  • 5
  • 32
  • 53
1
vote
1 answer

ODP.Net Unmanged x64 causes unhandled exception

for the past few years I have been using the Unmanaged driver for Oracle, the 32bit Version=4.121.2.0 from October 2015 Now I am trying to upgrade to use the new Oracle client and use the 64bit Version=4.122.18.3 When I try to connect to the…
Gerrie Pretorius
  • 3,381
  • 2
  • 31
  • 34
1
vote
2 answers

Oracle.DataAccess.Client and .NET Framework errors in Microsoft Excel

[WIN10 - 64Bit] I am trying to connect to Oracle (12c) from Excel (64-Bit) but am having issues. From the OTN I have installed ODAC 12.2.0.1.0, which includes: Oracle Data Provider for .NET 12.2.0.1.0 Oracle Providers for…
need_java
  • 127
  • 2
  • 4
  • 13
1
vote
0 answers

Confused about ODAC (xcopy version) installation path

As I am getting this notorious error 'The provider is not compatible with the version of Oracle client' with my asp.net application, I am trying to install the same ODAC version which my team is using: ODAC 11.2.0.4.0. So, I downloaded it and…
Stack0verflow
  • 1,148
  • 4
  • 18
  • 42
1
vote
1 answer

Oracle.DataAccess (ODAC)18.3 not found in iis(4.122.18.3)

3) but in installation there are no machine level option. I put Oracle.DataAccess and Oracle.Web in to gac manually and add DbProviderFactories to machine.config.But I got still this error. Is someone try this odac version with iis server Could not…
Bilgehan
  • 1,135
  • 1
  • 14
  • 41
1
vote
1 answer

Oracle developer tools for VS 12c not working with VS 2010

I have a project which is developed in VS 2010 and when I try to update the edmx file it is not at all working. I have uninstalled and installed the ODT many times but nothing is working. while installing also the installation window does not…
Arunprasanth K V
  • 20,733
  • 8
  • 41
  • 71
1 2 3
…
16 17