locked
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater While attempting to create a dataset on Local Machine (Report Builder 3.0) RRS feed

  • Question

  • I am developing SSRS Reports through Report Builder 3.0. We have Oracle databases that i am attempting to create datasets from. Although I enter the correct password as specified in the Data Source, I receive the error "Unable to connect to data source 'DataSource'" with System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I have installed 32 bit Oracle 11g Client on my local machine (windows 7 Pro 32 bit) but i still cannot create a dataset. I am able to create a data source succesfully on the server. I checked the permissions on the Oracle/home folder and my profile has Full Control. I'm pretty much out of ideas. Any help?

    Thank you very much!

    Wednesday, June 27, 2012 5:52 PM

Answers

  • Hello Kburckhart,

    Thank you to communicate with TechNet forum.

    For this issue, I consider that the user does not have the enough permission to access the ORACLE_HOME folder. In order to narrow down this issue, please try to follow the next steps to see whether they can solve this issue.

    1. Log on to Windows as a user with Administrator privileges on the Oracle server.
    2. Start Window Explorer and navigate to the ORACLE_HOME folder.
    3. Choose properties on the ORACLE_HOME folder.
    4. Click the "Security" tab of the "Properties" window.
    5. Click on "Authenticated Users" item in the "Name" list.
    6. Un-check the "Read and Execute" box in the "Permissions" list under the "Allow" column.
    7. Re-check the "Read and Execute" box under the "Allow" column.
    8. Click the "Advanced" button and in the "Permission Entries" verify that "Authenticated Users" are listed with permission = "Read & Execute", and Apply To = "This folder, subfolders and files". If not, edit that line and make sure that "Apply To" drop-down box is set to "This folder, subfolders and files". This should already be set properly but it is important that you verify it.
    9. Click the "Ok" button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.
    10. Reboot, to assure that the changes have taken effect.

    I hope it is helpful to you. If you have any questions about this issue, please let me know.

    Regards,

    Edward


    Edward Zhu

    TechNet Community Support

    • Proposed as answer by Edward Zhu Monday, July 2, 2012 10:05 AM
    • Marked as answer by Edward Zhu Monday, July 9, 2012 2:24 AM
    Monday, July 2, 2012 8:45 AM

All replies

  • Hello Kburckhart,

    Thank you to communicate with TechNet forum.

    For this issue, I consider that the user does not have the enough permission to access the ORACLE_HOME folder. In order to narrow down this issue, please try to follow the next steps to see whether they can solve this issue.

    1. Log on to Windows as a user with Administrator privileges on the Oracle server.
    2. Start Window Explorer and navigate to the ORACLE_HOME folder.
    3. Choose properties on the ORACLE_HOME folder.
    4. Click the "Security" tab of the "Properties" window.
    5. Click on "Authenticated Users" item in the "Name" list.
    6. Un-check the "Read and Execute" box in the "Permissions" list under the "Allow" column.
    7. Re-check the "Read and Execute" box under the "Allow" column.
    8. Click the "Advanced" button and in the "Permission Entries" verify that "Authenticated Users" are listed with permission = "Read & Execute", and Apply To = "This folder, subfolders and files". If not, edit that line and make sure that "Apply To" drop-down box is set to "This folder, subfolders and files". This should already be set properly but it is important that you verify it.
    9. Click the "Ok" button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.
    10. Reboot, to assure that the changes have taken effect.

    I hope it is helpful to you. If you have any questions about this issue, please let me know.

    Regards,

    Edward


    Edward Zhu

    TechNet Community Support

    • Proposed as answer by Edward Zhu Monday, July 2, 2012 10:05 AM
    • Marked as answer by Edward Zhu Monday, July 9, 2012 2:24 AM
    Monday, July 2, 2012 8:45 AM
  • Hello,

    I am experiencing this issue even after doing the recommended steps with permissions. Are other thoughts on it?

    Monday, April 24, 2017 10:52 AM