cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Connect to PostgreSQL

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.

6 REPLIES 6
Highlighted
Advocate II
Advocate II

Re: Connect to PostgreSQL

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.

Highlighted
New Member

Re: Connect to PostgreSQL

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 Smiley Happy

 

 

Highlighted
New Member

Re: Connect to PostgreSQL

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?

Highlighted
Helper III
Helper III

Re: Connect to PostgreSQL

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

 

Any help is much appreciated.

 

Thanks,

indhu

Highlighted
New Member

Re: Connect to PostgreSQL

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 .

Highlighted
Frequent Visitor

Re: Connect to PostgreSQL

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.


 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors