Forum Discussion

Alex_Ooi's avatar
Alex_Ooi
Icon for Helper IV rankHelper IV
6 years ago

DataSource.Error: ODBC: ERROR [08001]

Hi all, I am connecting to my PostgreSQL dB using ODBC for Power BI. When I tested my connection in ODBC, it worked fine. When I tested the connection again in my IDE, it worked fine.   When I am t...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Alex_Ooi 

Try the troubleshooting solution here: https://www.ionos.com/community/hosting/postgresql/troubleshoot-a-postgresql-could-not-connect-to-server-error/

 

To correct this, edit your posgresql.conf file:

  • Ubuntu 16.04: sudo nano /etc/postgresql/9.5/main/posgresql.conf
  • CentOS 7: sudo nano /usr/pgsql-10/share/postgresql.conf

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Alex_Ooi's avatar
    Alex_Ooi
    Icon for Helper IV rankHelper IV
    6 years ago

    Anonymous I don't think this is applicable to me as I am using Windows OS. Apologies for not mentioning this earlier.