Received: from mail.gmx.net (pop.gmx.net [194.221.183.20])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0AIYAB49952
	for <pgsql-sql@postgresql.org>; Wed, 10 Jan 2001 13:34:10 -0500 (EST)
	(envelope-from magnus@gmx.de)
Received: (qmail 20011 invoked by uid 0); 10 Jan 2001 18:34:08 -0000
Received: from mnzdi7-213-023-004-006.arcor-ip.net (HELO mws) (213.23.4.6)
	by mail.gmx.net (mail07) with SMTP; 10 Jan 2001 18:34:08 -0000
From: Markus Wagner <mawagner@mail.uni-mainz.de>
To: pgsql-sql@postgresql.org
Subject: connecting to postgres server from Access
Date: Wed, 10 Jan 2001 19:39:27 +0100
X-Mailer: KMail [version 1.1.99]
Content-Type: text/plain;
  charset="iso-8859-1"
MIME-Version: 1.0
Message-Id: <01011019392703.01764@mws>
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200101/99
X-Sequence-Number: 760

Hi,

I'm running a postgres db server on my linux machine. Someone else would like 
to build his frontends with MS Access and use the postgres server as backend. 
He installed the Pg/ODBC-Driver linked to at the pg web site. But when he 
tries to link in some table he always gets an error message about wrong 
authentication. I inserted his IP address in the pg_hba.conf file and created 
a linux user account for him as well as a pg user account within "template1". 
So he could log in and use "createdb" to create his own db. I tried to set 
his password within pgaccess, but pgaccess claims about wrong input (""). 
Leaving the password field empty doesn't help to get the connection.  Then I 
set his password with "ALTER USER" in pgsql. But there still is no connection 
from access to pg yet.

Could someone help?

Thanks,

Markus