Which ODAC is required for Microsoft Report Builder 15.0.1944.0?

[RJARRETT]

Caveat.

I realize this is not a Microsoft Report Builder forum.  However, there does not appear to be any such forum and I believe there will be some Power BI folks who have run into this issue that might be able to help.  If you cannot help, but know where I can go to get help, please let me know.  Thanks.

What is the problem?

We recently updated to Windows 11 and my Microsoft Report Builder will no longer connect to Oracle. I had been running a Windows 10 machine, with Visual Studio 2019 Professional, Microsoft Report Builder and Microsoft Power BI with ODAC and everything worked. Starting with a fresh Windows 11, I cannot seem to get everything working.

Oracle Databases

The range of Oracle databases I am connecting to is 12c up to 19c. The most important for this discussion is the 12c version, because it is the version affecting my current project. Yes, it is old, but it is not scheduled for upgrade for 6-12 months.

Here is what I have installed:

Windows 11

Visual Studio 2022 Professional

Microsoft Report Builder 15.0.1944.0

Microsoft Power BI Desktop Pro

64-bit Oracle Data Access Components version 12.2.0.1.1 (ODTwithODAC122011)

With this combination, both Visual Studio 2022 Professional and Microsoft Power BI seem to be working properly.  I can even connect with ODBC 64 using the Oracle in OraClient12Home 12.01.00.02 driver.  So, I know that connectivity is possible.

Microsoft Report Builder

The problem was that Microsoft Report Builder was not connecting. We get this error…

Google to the Rescue

As usual, I checked Google. There are several posts on this topic and basically, they all suggest that I don't have the right version of ODAC installed. They all point to the Oracle Data Access Components (ODAC) for Windows Downloads website.

I have tried two installing two different versions (12.2.0.1.1 and 12.1.0.2.4) with similar results. The installer tells me that I need to install Visual Studio. Unfortunately, I already have Visual Studio 2022 Professional installed, so the message seems to be leading down a rabbit hole.

What used to work?

When we were working back on Windows 10 and Visual Studio 2019, we found that there were two variations on the ODAC, one that supported Microsoft Power BI Desktop Pro and another that supported Power BI Report Builder. P_ower BI Report Builder_ is not the same thing as Microsoft Report Builder, but they are very similar. The former is a cloud based version and the latter a LAN based version, for lack of a better term. In any case, our old Windows 10/VS 2019 seemed to work for all three products that we cared about using the 64-bit Oracle Data Access Components version 12.2.0.1.1 (ODTwithODAC122011).

Here were the two packages and our notes:

ODAC122011_x64 is used to allow Power BI Desktop Pro to connect.

ODTwithODAC122011 is used to allow Power BI Report Builder to connect.

What should we use?

Any ideas on what version we need for the Windows 11, Visual Studio 2022 Pro setup described above?

Rob

[v-stephen-msft]

Hi @RJARRETT ,

For Oracle configuration errors, it is advised to work with your Oracle support to understand and configure it correctly.

If you still face issues, you might want to consider downgrading your Visual Studio to the 2019 version, as it was working with your previous setup on Windows 10. However, this should be considered as a last resort if you cannot find a solution with the current setup.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.