Solved

What is the Oracle.DataAccess version number for oracle 11g

Posted on 2011-03-02
3
1,033 Views
Last Modified: 2013-11-11
What is the Oracle.DataAccess version number for oracle 11g? We downloaded win32_11gR2_client ran the setup and it installed this version: 2.112.1.0.

My co-worker thinks it should be something like 4.112.x.x.

I have no idea.

Can you please tell me which one we should use and where to get it.
0
Comment
Question by:bill_home
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 35020485
You won't like the answer to this...

First: From all my experience, the versions must match 100%.  Not even apps compiled with minor version differences will run.

That said:  The ODP.Net verions only recently follows the release numbers for the Oracle version and even now, only somewhat.

So for your DLL 2.112.1.0, that is supposed to mean:  11gR2 version 11.2.0.1.

The 'older' version 4.112.x.x, I've never seen a matrix that references the Oracle verions to DLL numbers.

Check the version of the client install where the 4.112.x.x DLL is residing.

If it's a  or above, it cal be downloaded from oracle.com.
0
 

Author Closing Comment

by:bill_home
ID: 35020634
right to the point and very helpful
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35020668
Glad to help.

I feel your pain.  I've bee fighting ODP.Net versions for a few years now!!!  Hopefully someday they'll get it worked out.  They are getting better!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle query help 18 99
Convert Oracle data into XML document 2 59
sql query 9 38
Create table from select - oracle 6 26
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now