Re: [SQL] connecting to postgres server from Access

On Wed, 10 Jan 2001, Markus Wagner wrote:

> 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.

First of all, questions about interfacing to PostgreSQL are better
directed to pgsql-interfaces list. You might not get much help posting to
the sql list.

What kind of authorization are you using in pg_hba.conf? (can you post the
line from pg_hba.conf for him)

What error message does he get in Access?

Can he connect to the database from another Linux/Unix machine via
psql? (or, from his Windows machine using a PostgreSQL-compatible command
interface, like isql)?

There's a FAQ on PostgreSQL + Access at www.scw.org/pgaccess. It may help
as well.

Good luck,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington