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

I tried this but got this error ORA-12154

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi mjsystemss,

    Thanks for reaching out in Microsoft Community Forum.

    The error usually indicates an issue with Oracle's network configuration. Please follow below steps to resolve the error;

    1. Make sure that the tnsnames.ora file is correctly configured and contains the necessary database alias and the file located in
    C:\Oracle\product\<version>\client_1\network\admin

    2.If using Instant Client, ensure that the TNS_ADMIN environment variable is set to the directory containing tnsnames.ora.
    echo %TNS_ADMIN%

    3.Make sure both Oracle client and ODAC are of the same architecture and plese Verify TNS_ADMIN Environment Variable and set it to correct directory containing tnsnames.ora.

    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.