Skip site navigation (1) Skip section navigation (2)


From: "Jose Avalis" <javalis(at)sympatico(dot)ca>
To: <pgsql-odbc(at)postgresql(dot)org>
Date: 2002-09-13 17:56:26
Message-ID: 00ce01c25b4e$e2e30260$647ba8c0@javier (view raw or whole thread)
Lists: pgsql-odbc
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 (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, 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, database PTEST1, user Jose. (#201)

   The non-sense thing is that: is MY TERMINAL'S IP ADDRESS, not which is the Postgres server address ; even when the ODBC Connection window is showing me the right address (

 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.



pgsql-odbc by date

Next:From: olibioDate: 2002-09-13 18:29:20
Subject: Inquiry From Form [pgsql]
Previous:From: Ben TrewernDate: 2002-09-13 16:37:54
Subject: datetime and ODBC driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group