ODBC driver set up to connect to Postgres data base

Hi
 i am trying to connect a Pc application to a PostgreS data base on Linux, I've got ODBC driver to Postgres, but when I am doing my application using visual C there is a message:( No pg_hba.config entry for host ***.**.**.* user hola,database adios ). I think that the DSN spefication for the ODBS are not right, so
How can I set up the ODBC driver to connect to a Postgres data base in another machine.
thanks
aboraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
compinfoConnect With a Mentor Commented:
It sounds like you have to modify (edit) the pg_hba.conf file and uncomment (delete the '#' in front of the word 'host') (or add) the line:

host all 0.0.0.0 0.0.0.0 trust

after this, stop the postmaster and restar it.  (find the process id and kill using this command: KILL -HUP pid)

Does this help??
Compinfo

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.