Thanks very much - that did the trick!
> -----Original Message-----
> From: Adam Haberlach [mailto:adam(at)newsnipple(dot)com]
> Sent: Wednesday, 28 March 2001 11:14 AM
> To: Jamz(at)AirNet(dot)Com(dot)AU
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] Installation Problem
> On Wed, Mar 28, 2001 at 10:49:36AM +0930, Jamz(at)AirNet(dot)Com(dot)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
> 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(at)newsnipple(dot)com | http://youlook.org
> http://www.newsnipple.com |
> '88 EX500 '00 >^< |
pgsql-interfaces by date
|Next:||From: dhninh||Date: 2001-03-28 03:59:34|
|Subject: connect to MS SQL server|
|Previous:||From: Adam Haberlach||Date: 2001-03-28 01:44:15|
|Subject: Re: Installation Problem|