PostgreSQL connection issue

Posts   
 
    
Marcin-eSc
User
Posts: 2
Joined: 04-Aug-2022
# Posted on: 04-Aug-2022 12:44:27   

Hi,

We are trying to configure connection to PostgreSQL database (version 9.4.9) in LLBLGen Pro v 5.9.2 but we have following error:

Exception information.

LLBLGen Pro version: v5.9. Build: 5.9.2

Exception details:

Message: Could not load file or assembly 'System.Threading.Tasks.Extensions, Version=4.2.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Source: Npgsql Stack trace:   at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<Open>g__OpenLong|0()   at Npgsql.NpgsqlConnection.Open(Boolean async, CancellationToken cancellationToken)   at Npgsql.NpgsqlConnection.Open()   at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData(Boolean showSuccess)

Inner exception: <null>

stack trace: LLBLGen Pro version 5.9. Build 5.9.2 -----[Core exception]--------------------   at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<Open>g__OpenLong|0()   at Npgsql.NpgsqlConnection.Open(Boolean async, CancellationToken cancellationToken)   at Npgsql.NpgsqlConnection.Open()   at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData(Boolean showSuccess)

Please advise.

Many thanks, Marcin

Walaa avatar
Walaa
Support Team
Posts: 14986
Joined: 21-Aug-2005
# Posted on: 04-Aug-2022 23:04:42   

Which version of Npgsql do you have on your system? Some versions required Npgsql to be manually deployed into the GAC

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39760
Joined: 17-Aug-2003
# Posted on: 05-Aug-2022 09:20:04   

I recall this message, it’s related to npgsql when using the latest version of npgsql on .net framework (not .net core/6). From the top of my head I don’t recall which specific version does work or whether there’s a workaround, but I’m sure Shay of Npgsql will know. Could you please post an issue with the stacktrace on the Npgsql repo, I’m sure they’ll likely know what to do about it. It’s not related to our framework.

Frans Bouma | Lead developer LLBLGen Pro
Marcin-eSc
User
Posts: 2
Joined: 04-Aug-2022
# Posted on: 09-Aug-2022 13:40:49   

Otis wrote:

I recall this message, it’s related to npgsql when using the latest version of npgsql on .net framework (not .net core/6). From the top of my head I don’t recall which specific version does work or whether there’s a workaround, but I’m sure Shay of Npgsql will know. Could you please post an issue with the stacktrace on the Npgsql repo, I’m sure they’ll likely know what to do about it. It’s not related to our framework.

Hi Otis, do you know how to contact Shay? I have submitted query in StackOverflow as suggested in Npgsql support page, but I have no answer disappointed

many thanks in advance. Marcin

Walaa avatar
Walaa
Support Team
Posts: 14986
Joined: 21-Aug-2005
# Posted on: 09-Aug-2022 16:34:39   

Post the issue in the github repo

I can see Shay replies promptly there.