Unable to find an entry point named 'SyncWriteTraceOrNot' in DLL 'OraOps19.dll'

[Wilsonjr]

Attempting to make connection with PowerBI Desktop to an on-prem oracle server. However I am recieving the following error:

I have already attempted reinstalling Oracle 19.3 driver, reinstalled Oracle Client for Microsoft Tools, reinstalled PowerBI desktop to make sure it was the latest version. All still result in the same error.

I do have 3 versions of the oracle driver 

Oracle 19.3 x64

Oracle 19.3 x32 (For on-prem SSIS that is being upgraded to 64 but need 32 for now)

Oracle 12.2 x64 (For Paginated Reports)

Any suggestions or answers would be hugely appreciated! Let me know if you need any extra info!

[v-zhangti]

Hi, @Wilsonjr 

Please refer to the following links in the hopes of helping you.
Solved: Unable to connect - We encountered an error while ... - Microsoft Fabric Community

Solved: Unable to connect to Microsoft SQL Server "An Erro... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[Wilsonjr]

I have attempted to uninstall and reinstall the .net 4.8 framework and restarted my pc and had no luck. Same error appeared. I Also did as the other post recommended and removed existing connections and tried connecting from a blank powerBI file. Additioally I cleared all cache. All resulted in the same "Unable to find an entry point named 'SyncWriteTraceOrNot' in DLL 'OraOps19.dll" error.

[Wilsonjr · Accepted solution]

Alright, I finally found a soution, the issue was my ODAC. I downloaded the latest 19c version of ODAC Xcopy 64 bit and it fixed the issue.

Oracle .NET, Visual Studio, and VS Code ODAC Downloads for Oracle Database