Обсуждение: POSSIBLE BUG.
Hi guys, good afternoon.
Sorry for bother you, but I'm having problems in accessing Postgres/Linux Red Hat from my Access DB
The thing is that I need to make an interface between my current Access database and a new Postgres DB, so I've downloaded the ODBC Client version 7.02.00.02 (FULL) and I've installed it in a terminal with Windows 98 and it is working fine, then I've installed te same version in another Windows 2000 Porfessional (Spack2) terminal and I couldn't connect to the Postgres DB.
My Postgres DB is called PTEST1 and the user is jose with password josex the Linux server's IP address in where Postgres is, is 192.168.1.5, so this is the address that I've set in the ODBC dialog window in my Win2k terminal (control Panel -> Adm. tools -> ODBC data sources)
When I try to connect from Access, Excel, etc) this error comes up:
ODBC Failed
No pg_hba.conf found, server 192.168.1.100, database PTEST1, user Jose. (#201)
The non-sense thing is that: 192.168.1.100 is MY TERMINAL'S IP ADDRESS, not 192.168.1.5 which is the Postgres server address ; even when the ODBC Connection window is showing me the right address (192.168.1.5)
I've tried the same ODBC Driver in a Windows ME edition and it worked fine.
Do you have any idea or suggestion ??? I need to put it to work in a Win2K ws.
Thanks a lot for your time, I'll really appreciate your help.
Have a nice day.
JOSE
-----Original Message-----
From: Jose Avalis [mailto:javalis@sympatico.ca]
Sent: 13 September 2002 18:56
To: pgsql-odbc@postgresql.org
Subject: [ODBC] POSSIBLE BUG.Hi guys, good afternoon.Sorry for bother you, but I'm having problems in accessing Postgres/Linux Red Hat from my Access DBThe thing is that I need to make an interface between my current Access database and a new Postgres DB, so I've downloaded the ODBC Client version 7.02.00.02 (FULL) and I've installed it in a terminal with Windows 98 and it is working fine, then I've installed te same version in another Windows 2000 Porfessional (Spack2) terminal and I couldn't connect to the Postgres DB.My Postgres DB is called PTEST1 and the user is jose with password josex the Linux server's IP address in where Postgres is, is 192.168.1.5, so this is the address that I've set in the ODBC dialog window in my Win2k terminal (control Panel -> Adm. tools -> ODBC data sources)When I try to connect from Access, Excel, etc) this error comes up:ODBC FailedNo pg_hba.conf found, server 192.168.1.100, database PTEST1, user Jose. (#201)The non-sense thing is that: 192.168.1.100 is MY TERMINAL'S IP ADDRESS, not 192.168.1.5 which is the Postgres server address ; even when the ODBC Connection window is showing me the right address (192.168.1.5)
You need to edit $PGDATA/pg_hba.conf on the server and add a suitable entry to allow connections from your workstation (192.168.1.100).
Regards, Dave.