Forum Discussion

mjsystemss's avatar
mjsystemss
Resolver I
1 year ago
Solved

Problem installing ODAC file for 32bit Report Builder

Hello, I need help with resolving this error. I am installing Oracle database drivers for Report server and to be able to use the 32 bit report builder application. I could not find the ODAC file 3...
105
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mjsystemss,

    Thank you for reaching out in Microsoft Community Forum.

    Pleaase follow below steps to resolve the error;

    1. please download the latest 32-bit ODAC directly from Oracle’s official site:  https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html

    2.Make sure the 32-bit ODAC path is listed before the 64-bit path in the PATH environment variable to avoid conflicts.

    3.if you're using both 64-bit and 32-bit ODAC, there could be a conflict. Temporarily remove the 64-bit path from PATH or reorder it so the 32-bit ODAC path comes first.

    4.Restart the server and test the Report Builder again.

    Please continue using Microsoft community forum.

    If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

    Regards,
    Pavan.

  • mjsystemss's avatar
    mjsystemss
    1 year ago

    Thanks! The problem was the tnsnames.ora file. It was not located in the file client path. I dragged the file to the path.

mjsystemss's avatar
mjsystemss
Resolver I
1 year ago

Hello, Thanks for your feed back. I noticed that the file size is so small 32MB against the previous version of over 500MB.
In the past we run CMD prompt command to register odp.net but not mentioned anywhere in the steps.
Below are the screen shots from the steps different from the previous installation steps. A little confused on the file

 

 

 

 



  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi mjsystemss,

    Thanks for reaching out in Microsoft Community Forum.

    It looks like the file size difference is due to the version or type of ODAC package you downloaded. The 32MB file might be a lighter version, which does not include all components like ODP.NET. Please follow below steps to install;

    1. Make sure that the downloade the full ODAC package and not just a lightweight version, as this may explain the small file size (32MB). The full package should include all necessary components like ODP.NET.

    2.If the installation doesn’t automatically register ODP.NET, the customer may need to manually register it using the CMD prompt with the following command:
    C:\> gacutil -i "C:\path\to\ODP.NET.dll"

    3.Please follow the official Oracle ODAC documentation for the correct installation steps, as the process may differ between versions.

    Please continue using Microsoft community forum.

    If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

    Regards,
    Pavan.