Stack Overflow
Stack Overflow

Questions tagged [odac]

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

246 questions
0
votes
1 answer

Deploying ASP.NET application which access oracle database?

I have just developed .net application using visual studio 2008 on windows 7 which accesses remote oracle database 10g using ODAC ODTwithODAC1020221.exe and Oracle 10g express edition as it automatically installs oracle client. I do not certainly…
Xinus
  • 29,617
  • 32
  • 119
  • 165
0
votes
0 answers

SQL Management Studio do not recognize oracledbProvider

I am facing this problem: I have installed Oracle Client 11g 64bits version also ODAC 11g 64bits, I have modified PATH environment, but SQL Server Management Studio do not show the OracleDBProvider, If I try to execute "Export and Import Data"…
José Ch
  • 23
  • 1
  • 8
0
votes
1 answer

How to deal with an Oracle data source in SSIS?

I know, this is a frequently asked question, but I'm not able to solve my problem about how to use an Oracle database in SSIS. Oracle data source specs Configuration I installed ODTWithODAC121021 & ODAC121021_x64 I defined tnsNames.ora to…
K4timini
  • 711
  • 2
  • 14
  • 34
0
votes
2 answers

Getting "ORA-XXX: Message XXX not found; product=RDBMS; facility=ORA" instead of the custom exception on ODAC 12c

In my scenario I'm executing oracle store procedure from MS BizTalk orchestration via WCF-Custom adapter (oracleDBBinding). This procedure in negative scenario throwing custom exception (pl/sql RAISE_APPLICATION_ERROR). If BizTalk Send port is…
Piotr
  • 41
  • 1
  • 5
0
votes
1 answer

How can I use Oracle Data Access Components 11.2.0 with Visual Studio 2013

I am having a problem similar to this one. However, the only answer suggested there doesn't work for me. Specifically I am trying to upgrade from VS2010 to VS2013. I have an oracle database project (.oradbproj file type) as part of our main solution…
Jacob
  • 453
  • 5
  • 17
0
votes
2 answers

Is ODAC must for C# Oracle Database connectivity using ODP.net

I am new to Databases and .net! I have SQL developer 3.0 installed through which I can connect to the Oracle 11g Database server. The requirement is to write a C# program to connect to the oracle database and run query; in my visual studio 2013…
Nj_Acc
  • 38
  • 5
0
votes
1 answer

ODAC 12c Release 3 not bringing Tables Associations from DB

I've just installed ODPwithODAC 12c and I was able to connect to Oracle 12c Database successfully, all the tables was loaded in the designer but without any relations (foreign key constraints) between them. I am using Windows 8.1 (64 bit) ,Visual…
MKH
  • 25
  • 3
0
votes
1 answer

How can I develop using ODAC 12 for EF without interfere old Oracle versions?

I'm developing with VS 2013 (vb.net) and using ODAC12 with ODP.NET but the user have app that works with oracle 9 so when I install ODAC12 on his PC those app doesn't works. I configured the app.config with connection string …
Alvaronbg
  • 1
0
votes
1 answer

Retrieve Name value from ColumnAttribute for Entity Framework batch deletes

I want to implement batch delete (for performance reasons) in Entity framework like this: context.ExecuteStoreCommand("DELETE FROM {0} WHERE {1} = {2}", tableName, columnName, columnValue); I want to know how to get the column's name from the…
nazemian
  • 159
  • 1
  • 11
0
votes
2 answers

Asp.net and Oracle : OracleException

I am trying to install my web application to the server. I am using Windows 2012 R2, ASP.NET 4.5, Oracle 11g db server and ODAC121012xcopy_64. I extracted zip file, called "install.bat all c:\oracle oracle_home" command and "iisreset". Then, my web…
dokibi
  • 43
  • 8
0
votes
1 answer

Link Server Between MS SQL Server 2008 R2 and Oracle 8.1

I want create link server between Microsoft SQLServer 2008 R2 and Oracle , I installed ODAC112030_x64 and win64_11gR2_client and my link server setup like this code, I have an error when testing it, the error is: OLE DB provider "OraOLEDB.Oracle"…
Moein Mohebbi
  • 33
  • 8
0
votes
0 answers

Accessing Oracle case sensitive ROWID from MS SQL Server

I am having a oracle table where the ROWID column is having data which is duplicate but as the field is case sensitive its considering it as 2 different rows eg. 'Test' and TEST are considered different. when i am accessing this from MS SQL Server…
user3766289
  • 1
0
votes
0 answers

Oracle ORA-01029, Entity Framework Select VB.NET

I'm getting the following error when I try to get some data. Oracle.DataAccess.Client.OracleException ORA-01029: internal two task error at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr…
Barrios
  • 75
  • 1
  • 2
  • 9
0
votes
1 answer

How To Insert USERID (Type: Raw, Size: 16) from Ora_aspnet_users to Another Table

Sorry I cannot upload the screenshot due to the limited number of my reputation since I am a newbie here. ora_aspnet_user table with column name userid with datatype of Raw(16) link to Instruct Table with userid with datatype of Raw (16) - Other…
webexapps
  • 1
  • 4
0
votes
1 answer

Entity Framework for Oracle DB

I am trying to use Entity Framework to connect to an Oracle Database, but when I right click -> add new Item -> "ADO.NET Entity Data Model" -> Generate from Database -> New Connection, I can not find the Oracle Provider in the provider list. I have…
Aelgawad
  • 184
  • 1
  • 16
1 2 3
…
16 17