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:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]] > > Sent: Monday, 10 February 2003 9:44 PM > > To: [EMAIL PROTECTED] > > 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
