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 >^< |
>
