RE: Installation Problem

Thanks very much - that did the trick!

> -----Original Message-----
> From: Adam Haberlach [mailto:adam@newsnipple.com]
> Sent: Wednesday, 28 March 2001 11:14 AM
> To: Jamz@AirNet.Com.AU
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] Installation Problem
> 
> 
> On Wed, Mar 28, 2001 at 10:49:36AM +0930, Jamz@AirNet.Com.AU wrote:
> > 
> > Hello people,
> >     I have successfully installed (on WIn2k) and written a small
> > application that uses the Postgres ODBC driver, and have 
> come to install it
> > on the production Win2k machine and I get this error 
> > 
> > "Test Connection failed because of an error initializing 
> provider. No
> > pg_hba.conf entry for host 203.xx.xx.xx, user posrtgres, 
> database bmf"
> 
>     The server is complaining that you don't give the client's IP
> permission to connect.  You should check on the server in the 
> pg_hba.conf
> file (in the $PGDATA directory, I believe) and give the mentioned IP
> (or subnet) a privledge level that will let it connect.
> 
> 
> Adding the line:
> host         all         127.0.0.1     203.xx.xx.xx     trust
> 
> Should let that particular host connect...but you may want more...
> 
> -- 
> Adam Haberlach            |
> adam@newsnipple.com       | http://youlook.org
> http://www.newsnipple.com |
> '88 EX500    '00 >^<      |
>