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


From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Jose Avalis" <javalis(at)sympatico(dot)ca>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: POSSIBLE BUG.
Date: 2002-09-13 20:03:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

	-----Original Message-----
	From: Jose Avalis [mailto:javalis(at)sympatico(dot)ca] 
	Sent: 13 September 2002 18:56
	To: pgsql-odbc(at)postgresql(dot)org
	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
	  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

You need to edit $PGDATA/pg_hba.conf on the server and add a suitable
entry to allow connections from your workstation (
Regards, Dave.

pgsql-odbc by date

Next:From: Stefan AllersDate: 2002-09-15 19:59:30
Subject: fetch auto-increment
Previous:From: olibioDate: 2002-09-13 18:29:20
Subject: Inquiry From Form [pgsql]

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