topic Problem installing ODAC file for 32bit Report Builder in Report Server

Problem installing ODAC file for 32bit Report Builder

mjsystemss — Wed, 26 Mar 2025 15:23:24 GMT

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 32 bit zip file in oracle website so I used the old downloaded file to install for another user from a shared drive. The 64 Bit run successfully but the 32 bit gives this error. I will appreciate any help that can help solve this error.

Re: Problem installing ODAC file for 32bit Report Builder

Anonymous — Thu, 27 Mar 2025 06:56:38 GMT

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.

Re: Problem installing ODAC file for 32bit Report Builder

mjsystemss — Mon, 31 Mar 2025 19:03:48 GMT

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

Re: Problem installing ODAC file for 32bit Report Builder

Anonymous — Tue, 01 Apr 2025 11:35:16 GMT

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.

Re: Problem installing ODAC file for 32bit Report Builder

mjsystemss — Tue, 01 Apr 2025 20:29:37 GMT

I tried this but got this error ORA-12154

Re: Problem installing ODAC file for 32bit Report Builder

Anonymous — Thu, 03 Apr 2025 12:23:32 GMT

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.

Re: Problem installing ODAC file for 32bit Report Builder

mjsystemss — Thu, 03 Apr 2025 12:30:06 GMT

Thanks! This has been resolved. The Problem was that the Tnsnames.ora file was not in the client path. So I dragged the tnsnames.ora file into the path.

Re: Problem installing ODAC file for 32bit Report Builder

mjsystemss — Thu, 03 Apr 2025 12:31:29 GMT

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