Re: [SQL] connecting to postgres server from Access

From: Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de>
To: Joel Burton <jburton(at)scw(dot)org>
Cc: Markus Wagner <mawagner(at)mail(dot)uni-mainz(dot)de>, pgsql-sql(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [SQL] connecting to postgres server from Access
Date: 2001-01-12 09:22:16
Message-ID: 3A5ECCC8.29533538@imsd.uni-mainz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

Hi Joel!

> http://www.postgresql.org/users-lounge/index.html

Ok, my fault...

> > "cannot create index for the selected field"
> >
> > Then the linked table appears in the tables tab in Access. When trying
> > to open it, I get ("Organisation" is the table to be linked):
> >
> > "ODBC error:
> > error while executing the query
> > ERROR: Organisation: Permission denied (#1)"
>
> Haven't seen this exact error before.

> Are you sure that you found and turned off BOTH read-only options in the
> ODBC driver configuration? (I'm just wondering if this "can't
> create" error is a strange read-only twist.)

This might be an important hint. In the system ODBC configuration I
found that the connection was configured read-only, two times. I changed
both to not to be read-only. But nothing changed.

Then I found under "Protocol" three alternatives: "6.5/6.4", "6.3",
"6.2". So if this is the pg version then I have a problem, because I am
using pg 7.0.

> Also, you might try to take the error at face value: try to create an
> index on the Org field using psql, and see if you run across any errors.

I also tried that. No changes.

> Slimmer but less featureful is Zeos Database Explorer, available at
>
> http://www.zeos.dn.ua/eng/index.html
>
> This is basically a GUI version of psql.

I tried it. The command "show tables" lists my tables. But when making a
"SELECT * FROM <sometable>" I get "relation <sometable> does not exist".
Very strange...

> Either of these tools will let you try your query out from the Windows
> box, and will help us figure out whether this is a PG problem, an
> ODBC problem, an Access problem, etc.

Seems to be a pg problem?

Markus

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message D Johnson 2001-01-12 11:40:39 Re: MS Access memo datatypes
Previous Message Michael Davis 2001-01-12 04:38:11 RE: MS Access memo datatypes

Browse pgsql-sql by date

  From Date Subject
Next Message Alain Lavigne 2001-01-12 13:36:29 SQL question
Previous Message J.H.M. Dassen (Ray) 2001-01-12 07:43:32 Re: automated log-messages