Postgresql gateway failure

[AGo]

Hi!

With new update I thought Npgsql was no longer mandatory, but it seems to be if connecting with the gateway, so I followed the old path as always.

Updated .NET to last version 4.8 and installed Npgsql with GAC version 4.1.3. When adding datasource to gateway cluster I've got returned this error: The installed database provider 'Npgsql' targets an incompatible .NET Framework. Please install Npgsql version 4.0.10.0 or earlier.

Does this version combo of .NET and Npgsql has some problem. What versions should I use?

Thanks

[bob32]

I reinstalled Npgsql but this time making sure to select "GAC Installation" and it appears to be working now

[bob32]

I have the same issue (4.0.9 is installed). I installed PBI Desktop on the gateway server and connected to the same Postgres server without issue (with the same user)

[AGo]

@bob32 can you try installing precisely version 4.0.10.0 and tell me if it solves the problem?

[bob32]

@AGo I tried v4.0.10 already (the git tag/package does not specify another level of versioning, so I'm not sure if that is actually the *exact* version to which you refer) and it was the same error

[AGo]

Ok, thanks for your information, I hope someone from Microsoft can help us.

[v-lionel-msft]

Hi @AGo ,

"The installed database provider 'Npgsql' targets an incompatible .NET Framework. Please install Npgsql version 4.0.10.0 or earlier."

Please install Npgsql version 4.0.10.0 or earlier.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AGo]

That's what I did: installed Npgsql version is 4.1.3

[v-lionel-msft]

Hi @AGo ,

Please create support ticket .

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AGo · Accepted solution]

It's now working with npgsql (4.0.10 and GAC) downgrade, hope it will be fixed soon with a full implementation of the ADO .NET data provider in the gateway.