Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Posgresql connection not working

We have a dataset that imports from Postgresql. It works when published. It is configured to use gateway which is installed on the same machine where model was created - so npgsql package is present ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

As I mentioned in the update post, npgsql version 4.1.2 is already installed on the gateway machine, and the problem remains.

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Just now,I have tried to install npgsql version 4.1.2 and a lower version of npgsql, but  the problem as you mentioned remains,so pls be patient,it may need time till I find out the problem, once it get resolved ,I'll reply to you asap.

 

Best Regards,

Kelly

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Any updates?

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ，

       Things to get this to work:

       

      1. Install the Npgsql provider on the server that's hosting the data gateway (https://www.nuget.org/packages/Npgsql/4.0.2)

      2. Reboot the server

       

       

      Best Regards,
      Kelly