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.
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:
Visual Studio 2022 Professional
Microsoft Report Builder 15.0.1944.0
Microsoft Power BI Desktop Pro
64-bit Oracle Data Access Components version 184.108.40.206.1 (ODTwithODAC122011)
With this combination, both Visual Studio 2022 Professional and Microsoft Power BI seem to be working properly.
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 (220.127.116.11.1 and 18.104.22.168.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 22.214.171.124.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?