I searched the forum and found this post, but I'm still having issues: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18205

I read the llblgen documentation on how to add the DbProviderFactories.

Here are the details of my configuration:

LLBLGen: 3.1 (September 30th 2011)

Error Message:

Failed to find or load the registered .Net Framework Data Provider.

Stack Trace:

LLBLGen Pro version 3.1. Build September 30th, 2011 -----[Core exception]-------------------- 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()

.NET 4.0 is only framework installed. (I'm running LLBLGenPro.exe)

Database: PostgreSQL 8.4.10

Npgsql version in the GAC:

The Global Assembly Cache contains the following assemblies: npgsql, Version=2.0.11.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7, processorArchitecture=MSIL

LLBLGen.config.exe:

    <DbProviderFactories>
        <!-- Firebird -->
        <add name="Firebird Client Data Provider"
         invariant="FirebirdSql.Data.FirebirdClient"
         description=".Net Framework Data Provider for Firebird"
         type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" />
        <!-- PostgreSql -->
        <add name="PostgreSql Client Data Provider"
         invariant="Npgsql"
         description=".Net Framework Data Provider for PostgreSql"
         type="Npgsql.NpgsqlFactory, Npgsql, Version=2.0.11.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
    </DbProviderFactories>

What could I be missing? I've been a LLBLGen user for years using SQL Server database with no problems. I started working for a new company that uses PostgreSQL and convinced them LLBLGen is the way to go. I am going to need help getting this working in order to prove my point.

I got it to work.

I ran LLBLGen Pro .. (on .NET 4.0) and it was able to pick up the driver.

Is this as expected? I was under the impression that I should just be using the regular exe without a specific framework type.

Are there any positives/negatives that may come up from running this way?

usschad wrote:

I ran LLBLGen Pro .. (on .NET 4.0) and it was able to pick up the driver. Is this as expected? I was under the impression that I should just be using the regular exe without a specific framework type.

Are there any positives/negatives that may come up from running this way?

That is expected because of the .net version qf the installed provider. Thre is not negative effects in doing this.