Stack Overflow
Stack Overflow

Questions tagged [odac]

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

246 questions
0
votes
0 answers

Oracle.DataAccess.Client.OracleException with an Empty Message

been fighting this for a few days now and getting a little frustrated... I am working on a web service that consumes an oracle store procedure which returns a custom type object. To do so I have been working with Oracle ODT (unmanaged). Since I have…
Eyal
  • 1
  • 2
0
votes
1 answer

Oracle LN-function not supported in ODAC?

I'm working on a C# program getting out data from an Oracle database. I have ODAC installed (just updated to version 12.2c), connecting to a 12.1 Oracle database and referencing Oracle.DataAccess in my project In one of my queries, I want to use the…
schneiju
  • 115
  • 1
  • 1
  • 9
0
votes
1 answer

Excel 2016- Get & Transform does not work

when I go to Data -> New Query -> From Database; no matter what database I select, nothing happens On the first attempt a message on the bottom right says: "Connecting to .NET framework", but nothing happens after What is wrong? edit: I noticed…
machump
  • 1,207
  • 2
  • 20
  • 41
0
votes
1 answer

Exception trying to retrieve column with 'i' in the column name using ODAC in turkish

I'm hitting an exception when trying to access data from an Oracle database using ODP.NET (ODAC). The code goes like this: Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("tr-tr"); string s = "SELECT MyString from MyTable"; var conn…
Andy
  • 10,412
  • 13
  • 70
  • 95
0
votes
1 answer

ODAC11 Oracle 9

We have a problem using ODAC11 (client) and Oracle databases version 9.0 and 9.1. It returns error message ORA-604 (something about recursive error on level %). Has anyone else collided with this problem before?
Nickolodeon
  • 2,848
  • 3
  • 23
  • 38
0
votes
1 answer

odac client 11.2.0.1.2 installation/re-installation but no oracle submenu at view menu of VS 2010

To whom it may respond to , I have installed/re-installed odac client 11.2.0.1.2 but there is not any oracle sub-menu appearing in the view menu of Visual Studio 2010 Version 10.0.30319.1 RTMRel Any ideas as resolution? Thank you for your time and…
kayhan yüksel
  • 378
  • 2
  • 9
  • 24
0
votes
1 answer

ODAC 10.20221 visual studio integration

I've downloaded ODAC1020221.exe from oracle website. It installed 10g client but neither VS2008 nor VS2010 sees ODAC provider. Oracle client 11 doesn't work with our oracle server (9.1 version), but just for the sake of test I've tried to install…
Nickolodeon
  • 2,848
  • 3
  • 23
  • 38
0
votes
0 answers

Setting up .net site in IIS 8.5 (AWS)

My .net project (Any CPU) is referring to Oracle.dataaccess x86 version . In my local GAC the odac version is x86. But in the web server where it was installed previously was having AMB64 version of odac in GAC . The site was working without any…
Bala
  • 1,077
  • 5
  • 15
  • 35
0
votes
1 answer

How to use OracleConnection with different queries C#

I can't understand how to work with OracleConnection object Use it for all queries? Or one connection for one query? My program do: 1) Recieve data from Oracle DB (cursor) (~100.000 - 1.000.000 records) 2) For each selected record (id) update value…
Johnny Bravo
  • 27
  • 5
0
votes
1 answer

Visual Studio 2010 not connecting to Oracle

Here is my environment: 64-bit Operating System, x64 based processor Windows 10 Enterprise Visual Studio 2010 Oracle Client 64 11gR2 ODAC 64k ODAC 32k The issue is I can't get Visual Studio 2010 connecting to Oracle 11g Database. Tried…
kkazi
  • 1
  • 2
0
votes
0 answers

Error installing ODAC 12c with ODT for Visual Studio due to illegal character in node

I'm getting this error while installing ODAC with ODT in my Windows 7 x86 dev box: It reads: One or more node names 'pc_xxxx' contain one or more of the following invalid characters "_" My company network domain and my machine name both have an…
FuuRe
  • 152
  • 1
  • 7
0
votes
1 answer

asp.net core Oracle.DataAccess System.BadImageFormatException: Could not load file or assembly Oracle.DataAccess

I've added Oracle.DataAccess as reference to asp.net core project. I've only installed Oracle Data Provider for .Net when installed ODAC. I would like to make a simple example with Dapper on the project. public class Program { const string…
Umit Gunduz
  • 11
  • 1
  • 2
0
votes
0 answers

EF6 vs2013 32bit to DB Oracle 11.2g 64bit

Can I access the database oracle 11.2g 64bit with Visual-Studio-2013 on Windows 32bit which use the EF6, ODAC 12c Release 3 using the method Database First? because after I try I get an error when it will generate the model db I have the following…
arifai
  • 1
0
votes
0 answers

How to connect with oracle through visual studio 2012 (windows 7 6bit)

I want to connect with oracle using visual studio 2012 ultimate edition on windows 7 64 bit. I see documentation and help only for windows 7 32 bit. So please anyone guide me how to connect with oracle on windows 7 64 bit operation system, and which…
user3004110
  • 929
  • 10
  • 24
  • 36
0
votes
2 answers

The universal installer for ODAC cannot see Visual Studio

I just installed Visual Studio Community 2015 on my computer and tried to install ODTwithODAC121021 (32bit). Well, the Oracle universal installer tells me it cannot proceed because I have to install Visual Studio first. Can someone tell me how I can…
edd
  • 933
  • 2
  • 11
  • 24
1 2 3
…
16 17