通过

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

  • 项目

Today I have tried to connect to Oracle database using Business Connectivity Service (BCS) to crawl the data in the database so the end user can able to search this data but I got the following  error when try to Crawl the content source :

The error in SharePoint Log:

Errorinfo is "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."

I have installed Oracle Client 11g (11.2.0.1.0) on Search Servers (Index Servers) which is greater than 8.1.7 so as Mr. Moustafa arafa said in his post

https://moustafa-arafa.blogspot.com/2007/04/systemdataoracleclient-requires-oracle.html

It is a security issue, so to fix it simply do the following:

Go to the Oracle Client folder.
2- Right Click on the folder.
3- On security Tab, Add "Authenticated Users" and give this account Read & Execute permission.
4- Apply this security for all folders, Subfolders and Files (IMPORTANT).
5- Don't Forget to REBOOT your Machine; if you forgot to do this you will still face the same problem unless you restart your machine.

Comments

  • Anonymous
    February 12, 2012
    thank you

  • Anonymous
    April 10, 2012
    thank you

  • Anonymous
    October 01, 2012
    which folder U r talking abOut???

  • Anonymous
    October 02, 2012
    Root folder of Oracle Client for example if you install Oracle Client in C:Oracle then grant permission to this folder

  • Anonymous
    October 16, 2012
    Thank you.It really works ;)

  • Anonymous
    October 25, 2012
    HEY BRO I M USING WINDOWS 7 AND I GAVE ORACLE 10G AND I DID SAME THING U SAID ABOVE BUT ITS NOT WORKING BRO :( :(

  • Anonymous
    November 20, 2012
    Grate it works.

  • Anonymous
    February 13, 2013
    Thanks!

  • Anonymous
    February 21, 2013
    Same problem as GUARAV above: Using windows 7, set permissions on the folder and lo luck.  Still getting the error.

  • Anonymous
    March 25, 2013
    Great It works alot.

  • Anonymous
    May 19, 2013
    Cool, thanks. It works.

  • Anonymous
    August 28, 2013
    Same....Using Windows 7.... Setting permission not working

  • Anonymous
    November 08, 2013
    This is kind of a generic message. I tested an app that specified system.data.oracleclient namespace and it doesn't exist on the Windows 7 - which is new because on Windows XP you could see a Microsoft OLE DB Connection to Oracle - not any more and that is why I got this error. So it could be a security issue, but if you look in a UDL file you might that you don't have a Microsoft OLE DB provider for Oracle.

  • Anonymous
    April 15, 2014
    Thk, Brother!

  • Anonymous
    February 04, 2015
    Thanks

  • Anonymous
    September 01, 2015
    It's working..Thank You.

  • Anonymous
    October 28, 2015
    Thanks, works out perfectly

  • Anonymous
    November 03, 2015
    Thanks a lot .. It helps..

  • Anonymous
    December 06, 2015
    Tanks