How to Connect Post Gres Database using ODBC Connection

[089704318]

Hi,

I follow the instruction in thread699-1119777 but I am fail.
Here's my code:
OdbcConnection connection = new OdbcConnection("DSN=PostgreSQL");
connection.Open();
I got error when openning the connection. However, I will not see that error if connecting with Postgres installed in my computer. It only occured when I try to connect to Postgres Server in my intranet.
Can you show me how to solve this.

Thanks

 

[ceco]

probably this server is not configured to allow connections

see postgresql.conf -> listen_addresses
and pg_hba.conf for lines that allow connection from your computer and with what type of method ....

 

[089704318]

Thanks. It is really that. I connected the server now