Solved

ODBC driver set up to connect to Postgres data base

Posted on 2000-05-17
1
927 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:abora
1 Comment
 

Accepted Solution

by:
compinfo earned 30 total points
ID: 2942492
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Data quality checks 2 70
Display multiple images in report 12 118
SYbase 4 30
MySQL Query Using Up Memory 6 26
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question