From: Joe Shevland <shevlandj@kpi.com.au>
To: Michel Claes <Michel.Claes@dexia.be>
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: RE: Odbc postgresql database is readonly
Date: Thu, 29 Jun 2000 13:54:34 +1000
Message-ID: <MJEMLFCFPOPOFFFLIIDGKEGKCAAA.shevlandj@kpi.com.au> (raw)
In-Reply-To: <0976439588FF90BA*/c=be/admd=publilink/prmd=gkbccb/o=notes/s=CLAEM/@MHS>
There's two places to uncheck the read-only flag... in the datasource definition and also the global driver settings.
Also, make sure that your linked tables have a unique index or primary key defined as otherwise they'll be marked as read-only (Access needs a PK or index to do inserts/updates... well Access needs a lot of things :).
Cheers,
Joe
>-----Original Message-----
>From: pgsql-interfaces-owner@hub.org
>[mailto:pgsql-interfaces-owner@hub.org]On Behalf Of Michel Claes
>Sent: Tuesday, 27 June 2000 9:29 PM
>To: pgsql-interfaces
>Subject: [INTERFACES] Odbc postgresql database is readonly
>
>
>Hi,
>
>I have installed succesfully postgresql on my linux server, and
>psqlodbc on my NT4-SP5 workstation.
>When I try to connect to my database with access 97 it is always
>in readonly mode. I have unchecked the read-only options in the
>odbc manager, the problem persist...
>In psqlodbc.log you can see that readonly=1 (it should be 0).
>Do tou have a solution ?
>
>Odbc driver version 6.50.0000
>Postgresql version 6.3.2-15 running on debian server.
>
>Please find attached : psqlodbc.log, the odbc registry and the DSN
>registry. (I have replaced the password by '******').
>
>
>
>Regards.
>
>Michel.
>
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: shevlandj@kpi.com.au, Michel.Claes@dexia.be
Subject: RE: Odbc postgresql database is readonly
In-Reply-To: <MJEMLFCFPOPOFFFLIIDGKEGKCAAA.shevlandj@kpi.com.au>
* 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