Forum Discussion

Dickbale's avatar
Dickbale
New Member
1 year ago
Solved

Difficulties setting up Postgres in OnPrem Data Gateway

Hello,  I am currently facing an issue with connecting a postgres database via the OnPrem Data Gateway.  The MSSQL Databases worked instantly but PostgresSQL constantly throws the error: Unable t...
admin
v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

Hi Dickbale,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Dickbale's avatar
Dickbale
New Member
1 year ago

Hi sorry for the late reply, I was not able to access my work pc. 

No sadly this didn 't work, however after doing that and replacing the driver from the gateway with the one from PowerBI I get a new error now:
GW-Fabric: Please install Npgsql version 4.0.17.0 or earlier.
This is odd because I have this driver installed on the pc, and the dll inside of the gateway is this version as well.

Also I can connect to the database with PowerBi from that VM without issue. 

In rebooted the service multiple times now but it still doesn't work. 

thanks, 
Alex

    • esteemed5171's avatar
      esteemed5171
      Regular Visitor
      1 year ago

      Hello !
      I encounter the same error message when trying to connect to an On prem Data Gateway : "Please install Npgsql version 4.0.17.0 or earlier.".

      Did you find the solution to the problem ?

       

      Thank you for your help