Thanks. That did the trick. I knew there had to be a simple solution.
At 04:14 PM 2/11/03 +0800, you wrote:
>
> Mike,
> Have you tried adding an entry for the entire Internet?
> eg: IP: 127.0.0.1(could be anything) Mask: 0.0.0.0
>
> Mike.(also)
>
> > -----Original Message-----
> > From: Mike Alford
> [<mailto:mikea@syscon-intl.com>mailto:mikea@syscon-intl.com]
> > Sent: Monday, 10 February 2003 9:44 PM
> > To: pgsql-admin@postgresql.org
> > Subject: [ADMIN] ODBC and unknown i.p.
> >
> >
> > I am using postgres 7.3.1 on a slackware linux server and psqlodbc.exe
> > version 07.02.0005. I am a novice at both linux and postgres
> > administration. We are in the process of converting from a
> > SCO unix server
> > with Ingres1.2 database to the aforementioned linux/postgres
> > server. Our
> > application is distributed to customers around the world and uses ODBC
> > connections in VB applications. With our old system, we only
> > had to be able
> > to connect to the database server through ODBC and
> > user/password security.
> > It appears that there is another level with postgres--namely
> > the addition
> > of entries into pg_hba.conf, which include the i.p.and
> > subnet. Since this
> > is a distributed application, we have no way to know in
> > advance what the ip
> > and subnet of users at a given site will be, much less when a customer
> > changes his local network. I tried a VB app without an entry
> > in pg_hba.conf
> > and failed, but succeed when the entry is added.
> >
> > Is there an easy way around the pg_hba.conf problem? If not,
> > has anyone who
> > has dealt with this issue have any suggestions?
> > Do not try to solve all life's problems at once -- learn to dread each
> > day as it comes.
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >
> <http://www.postgresql.org/users-lounge/docs/faq.html>http://www.postgresq
> l.org/users-lounge/docs/faq.html
> >
Do not try to solve all life's problems at once -- learn to dread each
day as it comes.