Hello,

I have recently un-installed oracle 11g 11.2.0.2 client tools (ODP.Net) and installed new version of Oracle server(single instance) database (11g 11.2.0.3 - 32 bit). I have also updated the machine.config file with DataProvider details in the following folders:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

So the above change make it all the application works with the latest version ODP.Net. But when I tried to refresh the Datasource in the LLBLGen 3.1 (32 bit) designer, it throws the following errors. Could anybody tell how to make the LLBLGen work with the latest ODP.Net DLL?

Exception information.
=============================================================
LLBLGen Pro version: v3.1. Build: May 13th, 2011

Exception details:
=====================
Message: Failed to find or load the registered .Net Framework Data Provider.
Source: System.Data
Stack trace: 
   at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)
   at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
   at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.GetDbProviderFactory()
   at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.CreateConnection()
   at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData()

Inner exception: <null>

Hello,

When I select the LLBLGen from the following sub-menu from windows start menu, the desiger connects to the databse.

Start - All Programs - LLBGen Pro 3.1- LLBLGen Pro V3.1 (On .Net 4.0)

Thanks.

There are 3 different executables for LLBLGen Pro Designer.

LLBLGenPro_NET40.exe LLBLGenPro_x86.exe LLBLGenPro.exe

Most probably you have used different ones at each case, one of them could find the ODP.NET provider and the other did not.

If you are on a 64 bit machine then: - LLBLGenPro.exe looks for the .NET 2.0 version of odp.net on 64bit. - LLBLGenPro_NET40.exe looks for the .NET 4.0 version of ODP.NET on 64bit - LLBLGenPro_x86.exel ooks for the .NET 2.0 version of ODP.NET on 32bit.

Walaa wrote:

There are 3 different executables for LLBLGen Pro Designer.

LLBLGenPro_NET40.exe LLBLGenPro_x86.exe LLBLGenPro.exe

Most probably you have used different ones at each case, one of them could find the ODP.NET provider and the other did not.

If you are on a 64 bit machine then: - LLBLGenPro.exe looks for the .NET 2.0 version of odp.net on 64bit. - LLBLGenPro_NET40.exe looks for the .NET 4.0 version of ODP.NET on 64bit - LLBLGenPro_x86.exel ooks for the .NET 2.0 version of ODP.NET on 32bit.

Correction: in v3.1, LLBLGenPro_NET40.exe is a 32bit application and looks for ODP.NET on 32bit. In v3.5 (in beta now) we added a second one, which is explicitly 32bit and the LLBLGenPro_NET40.exe is compiled as AnyCPU, so it runs on 64bit if the OS is 64bit.

This is unclear in v3.1 from the description, hence we added a second one. By default, .NET 4 applications are 32bit, not AnyCPU. Changing it to AnyCPU is sometimes not working, it flips back to 32bit, which we found out a few months ago!