Unable to find Oracle ODP.NET driver

Posts   
 
    
jovball
User
Posts: 434
Joined: 23-Jan-2005
# Posted on: 14-Mar-2022 03:58:00   

I have Oracle ODP.NET (ODAC 19.3.1 x64) installed but the relational data wizard is saying "unable to find the requested .NET Framework Data Provider."

I am using LLBLGen Pro version 5.9. Build 5.9.0

I tried installing the Oracle.ManagedDataAccess.dll into GAC but that didn't change anything. We use the Oracle Nuget packages for running the application so it's quite likely that I don't have something installed correctly with ODP.NET but I don't have any idea where to look.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 14-Mar-2022 10:13:39   

Since quite some time the Oracle ODAC installer doesn't perform an additional step, which we've documented here: https://www.llblgen.com/Documentation/5.9/Designer/Databases/oracleodpnet.htm#registering-odp.net-in-the-gac-and-machine.config Did you perform those actions?

Frans Bouma | Lead developer LLBLGen Pro
jovball
User
Posts: 434
Joined: 23-Jan-2005
# Posted on: 09-Apr-2022 15:30:41   

Yes, of course that was the reason. It's the usual "read the documentation last" approach.