Re: Can't get ODBC from Windows to Linux/Postgres to work, SOLVED!

From: "Jeff Martin" <jeff(at)dgjc(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can't get ODBC from Windows to Linux/Postgres to work, SOLVED!
Date: 2002-03-12 17:18:53
Message-ID: NEBBLNMDMLIJEILLDFNBOEKFCGAA.jeff@dgjc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ODBC connectivity to my PostgreSQL/Linux box has been solved, thanks!

The problem was when I set the ODBC parameters on my windows box I
identified
my Linux box by name "www.myname.org". However, since my ISP provides DNS
for
me the IP address returned was my external IP address rather than my
intranet address.
The solution was to simply put in my intranet address for the machine name.
Also related
was my permissions in the pg_hba.conf file. I only want to allow access
from machines
on my intranet. Presto it worked. I did make one other change. Windows
ODBC seems to
allow you to configure an ODBC as a user level or machine level. I also
switched that
from the user level to the machine level ODBC.

Summary of other lessons learned from your responses.

1. If using IDENT authentication an identd deamon needs to run on the
Windows (client) box.
And yes there is a identd deamon available for windows.

2. The --enable-odbc compile flag for PostgreSQL is only needed when using
ODBC from
Linux to Linux.

Thanks for the help,

Jeff

Jeff Martin
704 Torrey Lane, Apartment D
Boalsburg, PA 16827
H814-466-7791
jeff(at)dgjc(dot)org <mailto:jeff(at)dgjc(dot)org>
www.dgjc.org <http://www.dgjc.org>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Koenig 2002-03-12 17:46:46 Re: cannot initdb
Previous Message John Gray 2002-03-12 17:18:35 Re: Zlib vulnerability heads-up.