How to solve system.data.oracleclient requires oracle client software version 8.1.7 or greater?

Question

1.00/5 (1 vote)

See more:

Hi All,

Currently am working for migration from oracle 11g to SQL server 2012, and after googling we found that SSMA (SQL server migration assistant) tool is available with more flexibility for migration.

Now am trying to do it my local with dev environment.I have oracle in dev server and sql server in another dev server.I installed SSMA in my machine and trying to connect Sql server and oracle.

SSMA able to connect Sql server from my machine but when I try to connect Oracle am seeing below error

C#

Connection to Oracle failed.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

I searched in the google for this issue and saying install oracle client and ODAC.

My concern here is do I need to install Oracle on Dev server of MS Sql server? if this is the case,how to proceed in Production?

Could you please suggest

What I have tried:

I have tried to install ODAC from Oracle.

Posted 7-Mar-16 0:25am

pratap420

Updated 7-Mar-16 2:21am

Add a Solution

Comments

Mehdi Gholam 7-Mar-16 6:55am

For migration to work you only need one machine to read from Oracle, so install the drivers on that machine.

2 solutions

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)

Dave Kreskowiak · Accepted Answer · 2016-03-07T02:21:00

Solution 2

You have to do exactly what the error message says. On your workstation where you're using SSMA, you must install a version of the Oracle Client software greater than version 8.1.7. In the case of an oracle 11 server, you have to install Oracle Client 10 or greater.

Posted 7-Mar-16 2:21am

Dave Kreskowiak

Comments

pratap420 7-Mar-16 12:00pm

Here client means Oracle software? or any driver?

Dave Kreskowiak 7-Mar-16 13:05pm

It's the CLIENT. Oracle Database 11g Release 2 for Microsoft Windows (32-bit)[^].

The client is the second link down, where it says 684,581,290 bytes.

pratap420 15-Mar-16 5:22am

thank you for your support...Now its working

Maciej Los · Accepted Answer · 2016-03-07T02:18:00

Solution 1

Download and install Oracle Data Provider for .net[^].
Then you'll be able to connect to oracle database.

Posted 7-Mar-16 2:18am

Maciej Los

Comments

pratap420 7-Mar-16 12:10pm

Thanks for your suggestion.Could you please clarify,data provider should I install in my machine or Oracle dev box or sql server dev box?

Maciej Los 7-Mar-16 12:45pm

Client machine

pratap420 15-Mar-16 5:22am

thank you for your support...Now its working

Maciej Los 15-Mar-16 16:44pm

You're very welcome. Can you accept this answer as a solution - formally, to remove your question from unanswered list?