Skip site navigation (1) Skip section navigation (2)

RE: Odbc postgresql database is readonly

From: "Joe Shevland" <shevlandj(at)kpi(dot)com(dot)au>
To: "Michel Claes" <Michel(dot)Claes(at)dexia(dot)be>, "pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: Odbc postgresql database is readonly
Date: 2000-06-29 03:54:34
Message-ID: MJEMLFCFPOPOFFFLIIDGKEGKCAAA.shevlandj@kpi.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)hub(dot)org
>[mailto:pgsql-interfaces-owner(at)hub(dot)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.
>


In response to

pgsql-interfaces by date

Next:From: Adam WalczykiewiczDate: 2000-06-29 07:38:19
Subject: SPI documentation
Previous:From: Joe ShevlandDate: 2000-06-29 02:16:47
Subject: RE: still confuse; no suitable driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group