Forum Discussion
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 trying to establish connection to Power BI, it returns this error message:
DataSource.Error: ODBC: ERROR [08001] could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5431?
FATAL: password authentication failed for user "readonly"
I don't know what's wrong because I am very sure the password is exactly what is given to me by my IT admin guy. Please help.
5 Replies
Alex_Ooi , are you giving correct url, it looking for localhost?
amitchandak hi, thanks for your reply. Yes, I am giving the correct url. Like I said, there is no problem with the connection when I established it in ODBC and my IDE.
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.Anonymous I don't think this is applicable to me as I am using Windows OS. Apologies for not mentioning this earlier.
