Re: [ADMIN] reg db access from windows

[sandhya]

If i am using local host......Should we not use IP addree of that . like: char ConnInfo[]={"dbname=pilot user=postgres password=megarac host=localhost port=5432"}; When iam giving host = 10.9.8.54(local ip where the DB is running)...The following error iam getting Connection to database failed FATAL:  no pg_hba.conf entry for host "10.0.0.205", user "postgres", database "pilot", SSL off Press any key to continue   Please tell me why is it so?   -Sandhya     ----- Original Message ----- From: sandhya To: postgre Cc: sandhya Sent: Wednesday, January 04, 2006 6:17 PM Subject: [ADMIN] reg db access from windows Hi...  When i am trying to connect to the database in the local windows system where database server is running as service I am getting the following error message.   Connection to database failed FATAL:  no pg_hba.conf entry for host "10.0.0.205", user "postgres", database "pilot", SSL off Press any key to continue   The following is there in pg_hba.conf.sample file   @authcomment@   # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD   @[EMAIL PROTECTED] "local" is for Unix domain socket connections only @[EMAIL PROTECTED]   all         all                               @authmethod@ # IPv4 local connections: host    all         all         127.0.0.1/32          @authmethod@ # IPv6 local connections: host    all         all         ::1/128               @authmethod@   Please tell me what i need to do.I used it in Linux and working fine.This is first time i am working in windows. Please suggest me how to proceed.   Thank you...   -Sandhya