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
Message-ID: <01011019392703.01764@mws> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mawagner@mail.uni-mainz.de, pgsql-sql@postgresql.org
Subject: Re: connecting to postgres server from Access
In-Reply-To: <01011019392703.01764@mws>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox