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

POSSIBLE BUG.

From: "Jose Avalis" <javalis(at)sympatico(dot)ca>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: POSSIBLE BUG.
Date: 2002-09-13 17:56:26
Message-ID: 00ce01c25b4e$e2e30260$647ba8c0@javier (view raw or flat)
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 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


   

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-2014 The PostgreSQL Global Development Group