Fix “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error in .NET

By | September 30, 2013

Introduction

In this article I will explain cause and resolution of “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error

Cause

This error generally occurs when you deploy an application on the server that access Oracle database using “System.Data.OracleClient” library and it doesn’t find the library on the server.

Resolution

To resolve this error you need to install Oracle Data Access Components (ODAC) with Xcopy deployment on the server which enables Oracle Data Provider for .NET (ODP.NET). Please follow these steps to install ODAC on the server

Step 1: Download ODAC component

For 32-bit download ODAC1120320Xcopy_32bit.zip from here

For 64-bit download ODAC112021Xcopy_x64.zip from here

You have to sign up to download these from oracle.com. I will download and install ODAC for 64-bit.

Step 2: Extract downloaded zip file anywhere on the system for example on the Desktop

Step 3: Open Command Prompt (cmd) and run following command to change directory to the extracted folder:

cd C:\Users\deepak\Desktop\ODAC112021Xcopy_x64

Step 4: Run following command in the Command Prompt to install Oracle Data Access Components

install.bat odp.net20 c:\oracle\11.2\odac odac11

Step 5: Add following paths of the installed ODAC components in the Path environment variable of the system

C:\oracle\11.2\odac

C:\oracle\11.2\odac\bin

Follow these steps to add paths to the environment variable

Step 5.1: Right click on “Computer” and select “Properties” to open the System properties

Step 5.2: Click on “Advanced system settings” to open “System Properties”

Step 5.3: Click on “Environment Variables” button under “Advanced” tab to open “Environment Variables” window

Step 5.4: Double click on the “Path” variable in the “System Variables” (scroll down if it’s not visible) section to edit the “Path” variable

Step 5.5: Add C:\oracle\11.2\odac;C:\oracle\11.2\odac\bin; at the beginning in the “Variable value” TextBox

Step 5.6: Close all the windows by clicking on “OK” button

Step 6: Restart your system.

 

0 thoughts on “Fix “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error in .NET

  1. Howardrah

    Your comment is awaiting moderation.

    Whoa a good deal of good tips!
    http://canadianpharmaciesnnm.com/
    safeway pharmacy canadian pharmacies online canadian pharma companies canada pharmaceutical online ordering
    canadian drugstore online
    <a href="http://www.ikeaclub.biz.ua/lib/ajax/contact_us_form.php?form_ajax=contacts&name=Howardscork&email=zittel020eejf%40songwriter.net&phone=87571488134&message=+Incredible+many+of+amazing+tips%21+http%3A%2F%2Ftalahicc.com%2F+mail+order+pharmacies+canada+pharmaceuticals+online+best+canadian+pharmacies+canadian+cialis+%0D%0Atrusted+overseas+pharmacies+%0D%0Acanadadrugs+%0D%0Acanadian+pharmacies+online+prescriptions+%0D%0Abest+price+prescription+drugs+%0D%0Awalgreens+pharmacy+%0D%0Abuying+drugs+canada&security_code=%21UNKNOWN_TYPE%21&send=”>canadianpharmacy
    pharmacy online mexico
    the canadian pharmacy
    online canadian pharmacy
    prescription pricing

    Reply
  2. Howardrah

    Your comment is awaiting moderation.

    Regards! Good information.
    http://canadianpharmaciesnnm.com/
    compare rx prices top rated canadian pharmacies online online pharmacy no prescription needed canadian pharmacies-24h
    most reliable canadian pharmacies
    <a href="http://en.liimapuu.fi/albumi/liimapuuvalmistusjamateriaali/1488243?m=+++Incredible+loads+of+great+knowledge.+++http://talahicc.com/+++prescription+drugs+canada+%3Ca+href=%22http://canadianpharmaciesnnm.com/%22%3Ecanadian+pharmacies+that+ship+to+us%3C/a%3E+canadian+drugs+without+prescription+northwestpharmacy+++%3Ca+href=%22http://www.thisisyourglamour.com/glamour/e-13/?unapproved=44214&moderation-hash=05898ed625b7f86df01bc8226c3f828d#comment-44214%22%3Eprescription+cost%3C/a%3E+++%3Ca+href=%22http://sellingb2e.com/2017/03/whats-product-backstory/?unapproved=33994&moderation-hash=a995f697073071ae9f7d497272ff3bdd#comment-33994%22%3Ecanada+pharmacy+online+reviews%3C/a%3E+++%3Ca+href=%22http://mustafatek.com.tr/index.php/2016/05/10/98/?unapproved=10193&moderation-hash=426623c51468a2b4f698cfa8eb89bb86#comment-10193%22%3Eonline+canadian+pharmacy%3C/a%3E+++%3Ca+href=%22http://trystwithvanillagirl.com/fotd-minimal-everyday-makeup-look/?unapproved=162092&moderation-hash=b748158b7e578f2a6e2ece6313a265ea#comment-162092%22%3Eonline+pharmacy+no+prescription+needed%3C/a%3E+++%3Ca+href=%22http://meganandliz.com/2016/11/megan-liz-mannequining-challenge/?unapproved=59626&moderation-hash=159c4ca85e7a1b47a4d482db713532f4#comment-59626%22%3Eno+prescription+pharmacy%3C/a%3E+++%3Ca+href=%22http://rainmaker-gbd.com/2016/02/want-to-stay-connected-with-oil-gas/?unapproved=32369&moderation-hash=4a783225305d445ac35a3147bc1b3120#comment-32369%22%3Ecanadadrugs%3C/a%3E&s=HowardNex&err=captcha#album_comment”>canadian prescription drugstore
    drug prices comparison
    us pharmacy no prior prescription
    pharmacies near me
    buy prescription drugs online

    Reply
  3. QuentinBak

    Your comment is awaiting moderation.

    With thanks, I appreciate it.
    http://canadianpharmacymim.com/
    online prescription drugs canadian pharmacies-24h pharmacy near me canadian cialis
    medical information online
    canadadrugs.com pharmacy
    prescription drug price comparison
    canada drug
    canadian meds
    <a href="http://www.oyunuzayi.com/blog/?s=&submit=&comment=+Cheers.+Terrific+information.+http%3A%2F%2Fwww.canadianpharmacymsn.com%2F+canadian+rx+canadian+pharmacies-24h+no+1+canadian+pharcharmy+online+canadian+cialis+%0D%0Atrust+pharmacy+canada+%0D%0Asafe+canadian+online+pharmacies+%0D%0Adrugs+from+canada+%0D%0Acanadian+drug+store+%0D%0Aprescription+drug+assistance+%0D%0Abuy+prescription+drugs+without+doctor&author=QuentinMaign&email=zittel020eejf%40songwriter.net&url=http%3A%2F%2Fhttp%3A%2F%2Fcanadianpharmacyntx.com%2F&passthis=2U8%5Esok9lxB&comment_post_ID=1421&comment_parent=0″>canada pharmacies prescription drugs

    Reply
  4. QuentinBak

    Your comment is awaiting moderation.

    Kudos. Very good information!
    http://canadianpharmacysilo.com/
    cheap drugs online trust pharmacy canada online pharmacy canada online pharmacies of canada
    24 hour pharmacy
    canadian pharmacies that ship to us
    mail order pharmacy
    online pharmacy without prescription
    candrugstore com
    <a href="http://www.nationwidemarketing.com/blog/?form2mailerror&inquiry=Business+Development&fname=Brendantuppy&lname=Brendantuppy&email=stolzenberg334ziz%40dutchmail.com&company=google&phone1=87627394136&phone2=87329925389&phone3=84511164374&comments=+Thanks.+Helpful+information.+http://viagrawithoutadoctorsntx.com/+quel+dose+de+viagra+%3Ca+href=%22http://viagrawithoutadoctormsn.com/%22%3Egeneric+viagra+online%3C/a%3E+subaction+showcomments+viagra+smile+remember+%3Ca+href=http://viagrawithoutadoctorsntx.com/%3Eviagra+for+sale+uk%3C/a%3E?form2mailerror&inquiry=Business Development&fname=QuentinWer&lname=QuentinWer&email=zittel020eejf@songwriter.net&company=google&phone1=88531663286&phone2=89725749643&phone3=84262639575&comments= You've made the point. http://talahicc.com/ legitimate canadian mail order pharmacies top rated canadian pharmacies online mail order pharmacies canadian online pharmacies discount pharmacy online canadian drugs without prescription canadian pharmacies that are legit safe canadian online pharmacies canadian pharmacies online canada drug“>pharmacy tech

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *