topic Re: "No ODAC driver is found on the System" after September 2023 Update in Report Server

"No ODAC driver is found on the System" after September 2023 Update

steffeto — Wed, 25 Oct 2023 09:41:27 GMT

Hello,

since I've updated our on-Premise PowerBI Report Server to the newest Version September 2023, I can no longer connect to Oracle Databases with the following error message: "An error happened while reading data from the provider: 'No ODAC driver is found on the system. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the provider.'"

Before I installed the Update everything was working fine, tnsnames.ora is still correct and tnsping also works fine. I didn't change anything to the installed ODAC drivers or stuff like that, all I did was install the newest PowerBI Update.

Any suggestions on how to fix that error?

Re: "No ODAC driver is found on the System" after September 2023 Update

Eggy25 — Wed, 25 Oct 2023 19:24:09 GMT

I had the same issue, fixed it by downgrading the Power BI version (July version works fine) Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn. I have no clue how to establish the connection on the new release.

Re: "No ODAC driver is found on the System" after September 2023 Update

Anonymous — Fri, 27 Oct 2023 06:36:40 GMT

Hi,

You need to install the latest version of "Oracle-Client-For-Microsoft". This is the link: Oracle Client for Microsoft Tools.

K r.

Re: "No ODAC driver is found on the System" after September 2023 Update

kblackburn — Fri, 27 Oct 2023 15:30:09 GMT

Hi, we are having the same issue. Can anyone confirm that installing the latest Oracle Client resolved the issue? Thanks

Re: "No ODAC driver is found on the System" after September 2023 Update

Anonymous — Sat, 28 Oct 2023 15:42:12 GMT

We were having this issue and after installing the x64 version from the link provided and pointing it to our TNS folder during installation the error went away.

Re: "No ODAC driver is found on the System" after September 2023 Update

kblackburn — Sun, 29 Oct 2023 17:54:52 GMT

Thank you!

Re: "No ODAC driver is found on the System" after September 2023 Update

Eggy25 — Mon, 30 Oct 2023 14:27:35 GMT

Did you follow the instructions in the attached PDF, or did you just install the x64 version without any further complications? I need to be pretty sure if it works, before I start testing out.

Re: "No ODAC driver is found on the System" after September 2023 Update

Anonymous — Wed, 01 Nov 2023 02:38:39 GMT

I downloaded the x64 version, ran the installer and the only thing I changed was the second file path where it asks to point to tnsnames.ora/sqlnet.ora. Gave it the correct file path to my TNS folder and that was it.

Re: "No ODAC driver is found on the System" after September 2023 Update

Eggy25 — Wed, 01 Nov 2023 07:26:55 GMT

Hi Maxwell

I did the same. It turned out to work. Thanks!

Re: "No ODAC driver is found on the System" after September 2023 Update

akhaliq7 — Tue, 14 Nov 2023 11:01:30 GMT

I have downloaded the latest version of Oracle Client for Microsoft Tools and created the tnsnames file (with the connection details) in the network\admin folder, uninstalled the old oracle client as it was not working with the latest September 2023 update, and getting the following error: Oracle: ORA-12637: Packet receive failed.

Re: "No ODAC driver is found on the System" after September 2023 Update

Anonymous — Tue, 14 Nov 2023 13:02:00 GMT

Hi, you need to be sure that you donwnloaded the aligned version of the tool. 32 ou 64 bits...

Re: "No ODAC driver is found on the System" after September 2023 Update

akhaliq7 — Tue, 14 Nov 2023 13:05:27 GMT

Yes, I have the same versions both 64 bit, I have put in a service request so hopefully will get a response back from the Power BI support team at Microsoft.

Re: "No ODAC driver is found on the System" after September 2023 Update

akhaliq7 — Wed, 15 Nov 2023 10:23:26 GMT

I have had to reinstall the older versions of both oracle client and power bi. Also created a service request ticket and could not be solved by the support team.

Re: "No ODAC driver is found on the System" after September 2023 Update

mvbenz — Thu, 30 Nov 2023 14:32:28 GMT

Thank You!!!! Installed and got the tnsnames error. This is what finally fixed it after a reinstall!

Re: "No ODAC driver is found on the System" after September 2023 Update

Kwesi — Sun, 24 Dec 2023 13:46:24 GMT

Hello Maxuell,

How did you give it a correct file path

I am having challenges doing that

Re: "No ODAC driver is found on the System" after September 2023 Update

Roberia — Thu, 28 Dec 2023 19:58:49 GMT

Oi! Estou com esse problema agora. Vou voltar para a versão de julho, como vc fez. Vc também criou a variável de ambiente TNS_NAMES? Em caso afirmativo, como vc apontou o caminho para o tnsnames.ora?

Re: "No ODAC driver is found on the System" after September 2023 Update

akhaliq7 — Tue, 09 Jan 2024 17:16:54 GMT

The latest version has resolved this issue for me Dec 18 2023.

Re: "No ODAC driver is found on the System" after September 2023 Update

gregHM — Mon, 05 Feb 2024 16:11:22 GMT

I upgraded to the Dec 2023 version of gateway. Encountered the ODAC error as well with existing oracle connections. Refreshes just failed. I don't really understand why this happened. I then installed the Oracle client for microsoft tools and it enabled me to do refreshes....it seems flakey though when I test the connections in the service from the gateway connections page. Sometimes they are online, sometimes offline......super weird and I hope we get information soon as to what caused this, I can't have these connections being unreliable.

Re: "No ODAC driver is found on the System" after September 2023 Update

akhaliq7 — Tue, 06 Feb 2024 09:57:58 GMT

if you work for a company then Power BI service will use the gateway to connect and not your local machine, also I use the older Oracle client with the latest Power BI version there are no issues, I did try the Oracle client for MS tools in my machine but that didn't want to work.

Re: "No ODAC driver is found on the System" after September 2023 Update

dkabala — Fri, 16 Feb 2024 21:46:50 GMT

Not for Power BI but ODBC connections within Excel. Path was - C:\oracle\product\19.0.0\client_1\network\admin\sample