Oracle Data Access, Changing Oracle Client Versions

Question

0.00/5 (No votes)

See more:

I have a webapplication that connects to an Oracle 11g database using ODP.NET 11. Everything has been working fine, but where I am working on this project, the company has an old legacy app which connects to an Oracle 7.3.4 database. I need to query this Oracle 7.3.4 database in the new web application. I have Oracle 8i client, but is there a way to switch the Oracle providers in the same running application? Im thinking I need to set DLLpath, but not too sure.

Any help would be greatly appreciated.

Posted 26-Mar-13 7:42am

Ryanm1324

Updated 26-Mar-13 8:24am

v3

Add a Solution

Comments

Prasad Khandekar 26-Mar-13 14:48pm

You don't have to switch the provider ODP.NET 11 provider will continue to work with Oracle 7.3.4. See this faq (http://www.oracle.com/technetwork/database/windows/faq-093106.html#integrate)

Ryanm1324 26-Mar-13 15:37pm

This error occurrs though:

The provider is not compatible with the version of Oracle client

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

Prasad Khandekar 26-Mar-13 15:48pm

With ODP.NET there is no need of a separate Oracle Client, the client library (OCI*.dll) is included with it.

Ryanm1324 26-Mar-13 16:53pm

When I try to use the one and query the Oracle 7.3.4 db I keep getting this:
"ORA-3134: Connections to this server version are no longer supported." "Oracle Data Provider for .NET"
Sorry, Im not sure what Im doing wrong

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ryanm1324 · Accepted Answer · 2013-03-27T07:32:00

Solution 1

I took a different approach and created a webservice that would take care of the access to Oracle 7.3.4 and return the data as an object list.
The rest continues to use ODP.NET for access to Oracle 11

Posted 27-Mar-13 7:32am

Ryanm1324