Postgres Pro
Downloads
Home   >   mailing lists

Thread: can't remote access from client with ODBC

can't remote access from client with ODBC

From
"Devi Munandar"
Date:
We run Postgres7.3.2 on a OpenBSD34
 I try to connect to the postgres database from winxp boxes using postgres odbc driver ver. 7.02.00.05
and then create a user dsn and then use a Borland Delphi tool called ODBCTest and try
but i get message "FATAL : no pg_hba.conf entry for host 192.168.228.59 user postgres database template1". and than try to edit pg_hba.conf  and added command "host      template1      postgres     192.168.228.59     255.255.255.0     trust" but still doesn't work. so I missed something with ODBC? 
 
dv

 

Re: can't remote access from client with ODBC

From
"Jouneau Luc"
Date:
Hi,
 did you asked the server to reload configuration files with a restart or a "pg_ctl reload" ?
lj
 
----- Original Message -----
Sent: Tuesday, January 18, 2005 11:22 AM
Subject: [ADMIN] can't remote access from client with ODBC

We run Postgres7.3.2 on a OpenBSD34
 I try to connect to the postgres database from winxp boxes using postgres odbc driver ver. 7.02.00.05
and then create a user dsn and then use a Borland Delphi tool called ODBCTest and try
but i get message "FATAL : no pg_hba.conf entry for host 192.168.228.59 user postgres database template1". and than try to edit pg_hba.conf  and added command "host      template1      postgres     192.168.228.59     255.255.255.0     trust" but still doesn't work. so I missed something with ODBC? 
 
dv