Connect to PostgreSQL

[vmbruno]

Hi everybody!

I'm trying to get data from a PostgreSQL database but it doesn't seem to work. I think I miss some of the components that need to be installed. When trying to setup a new connection I type in the database and server, and this is the error message I get:

"Unable to connect

Details: "PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'.
This error could've been the result of provider-specific client software being required, but missing on this computer.  To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=282716""

I've tried going npgsql website and install the required components but I can't seem to get it working. I'm not a developer so this is a bit complicated for me. Does anyone know how to get these components installed? I very much appreciate your help! 🙂

I'm using Windows 10 on a Surface Pro 3 if this helps. And I do have Visual Studio Community installed as well.

Best,

Bruno.

[Anonymous]

THanks for the solution guys installing old version of npgsql seems to be working 

https://github.com/npgsql/Npgsql/releases/tag/v2.2.4.3

---

@vmbruno wrote:

Hi everybody!

I'm trying to get data from a PostgreSQL database but it doesn't seem to work. I think I miss some of the components that need to be installed. When trying to setup a new connection I type in the database and server, and this is the error message I get:

"Unable to connect

Details: "PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'.
This error could've been the result of provider-specific client software being required, but missing on this computer.  To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=282716""

I've tried going npgsql website and install the required components but I can't seem to get it working. I'm not a developer so this is a bit complicated for me. Does anyone know how to get these components installed? I very much appreciate your help! 🙂

I'm using Windows 10 on a Surface Pro 3 if this helps. And I do have Visual Studio Community installed as well.

Best,

Bruno.

---

[sguenther]

Hey Bruno,

I was faced with the same problem and had to find the right installation files. What fixed it for me in the end was installing

Setup_Npgsql-2.2.4.3-net45.exe

Here is the link to the GitHub project:

https://github.com/npgsql/Npgsql/releases/tag/v2.2.4.3

Hope that helps.

Best

Sebastian

P.S.: Close your Excel and PowerBI Desktop during the installation. Otherwise you will run into a Token error.

[igour]

Not sure why just this libs(https://github.com/npgsql/Npgsql/releases/tag/v2.2.4.3) has worked but not the lastest from npgsql. 

Anyways thanks to @sguenther .

[vmbruno]

Hi Sebastian,

Thanlk you so much for your reply! I went to that page and ran that .exe file. I think something has definitely improved since PowerBI no longer tells me of the missing files. However I still can't connect to the database. This is the error that I'm getting after I type in the server and database address :

"Unable to Connect

We encountered an error while trying to connect.

Details: "PostgreSQL: Failed to establish a connection to 'ec2-54-217-246-62.eu-west-1.compute.amazonaws.com'.""

Do you have any idea why this might be happening? In Excel I don't even get the PostgreSQL option when adding a new source. Could this be from the setup I installed was not fully compatible with my system/version?

Best,

Bruno

[felipetancredo]

I'm getting the same problem:

PostgreSQL: Failed to establish a connection to 'xxxxxxxxxxx.us-west-2.rds.amazonaws.com'.

My Personal Gateway is installed on AWS west-2 region.

Any ideas?

[indhu]

Having same problem. @felipetancredo and @vmbruno did you solve it? 

Any help is much appreciated.

Thanks,

indhu