Problem with 'Refresh relational model data from a database'

Posts   
 
    
tmatelich
User
Posts: 95
Joined: 14-Oct-2009
# Posted on: 01-Apr-2013 23:28:43   

First try after upgrading from 2.6. Using Postgres. Not sure what I might be missing. Tried to poke around for npgsql.dll and in the .config. Couldn't find the former and the latter seemed fine

Exception information.

LLBLGen Pro version: v3.5. Build: January 17th, 2013

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(Boolean showSuccess)

Inner exception: <null>

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 02-Apr-2013 07:14:49   

You should add the DBProviderFactory manually on you .config file. Please read this...

David Elizondo | LLBLGen Support Team
tmatelich
User
Posts: 95
Joined: 14-Oct-2009
# Posted on: 02-Apr-2013 17:06:49   

I copied that Factory from LLBLGenPro.exe.config to my .configs to make them work, so I'd hope it was correct to start with. Perhaps you missed the subject line?

tmatelich
User
Posts: 95
Joined: 14-Oct-2009
# Posted on: 02-Apr-2013 17:59:18   

Now I'm wondering where npgsql.dll v 2.0.4.0 even is.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39910
Joined: 17-Aug-2003
# Posted on: 02-Apr-2013 19:11:18   

Just get the latest npgsql.dll from the postgresql foundry website. http://npgsql.projects.pgfoundry.org/

If you're installing the .net 4.0 version, be sure to run the v3 designer on .net 4 as well with the .net 4 runner (available in windows menu)

Frans Bouma | Lead developer LLBLGen Pro
tmatelich
User
Posts: 95
Joined: 14-Oct-2009
# Posted on: 03-Apr-2013 00:52:51   

Thanks, that worked.

So, am I the first person to use postgres on 3.x, did I miss something in the documentation, or do other people install npgsql somewhere on their system?

I just put it in my path of my software I write.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 03-Apr-2013 07:57:03   

tmatelich wrote:

Thanks, that worked.

So, am I the first person to use postgres on 3.x, did I miss something in the documentation, or do other people install npgsql somewhere on their system?

No, you are not the first one (i.e: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=19590)

Mostly the reason is the way .net tries to found the db provider factory and the version you have registered on your machine.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39910
Joined: 17-Aug-2003
# Posted on: 03-Apr-2013 10:10:17   

Indeed, it's not uncommon, it's just a bit cumbersome to get started with npgsql. simple_smile

Frans Bouma | Lead developer LLBLGen Pro