Thread: faq/archives & question

faq/archives & question

From
Tim Drury
Date:
A few questions (being new here):

(1) Is there a way to get to this lists' mail archives?

(2) Is there a PostgreSQL *interfaces* faq?  I've read
the primary PostgreSQL faq?

(3) Using Access/postdrv v6.5 to access my postgresql
ver 7 database works fine, but I cannot write to it.
I've turned off both "read only" checkboxes on the
settings dialog for the driver.  When I enter a value
into a field, it let's me type it in, but when I try
to move the cursor away from that field I get the
error: "ODBC--call failed. Connection is readonly,
only (#1)".  

I assume this is probably a FAQ, but since I cannot
find the FAQ, any help?

-tim


Re: faq/archives & question

From
"Adam Lang"
Date:
Answers inline....

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Tim Drury" <tdrury@NetVendor.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Monday, October 09, 2000 3:15 PM
Subject: [INTERFACES] faq/archives & question


>
> A few questions (being new here):
>
> (1) Is there a way to get to this lists' mail archives?

http://www.postgresql.org/mhonarc/  And just go to the relevant folder.

>
> (2) Is there a PostgreSQL *interfaces* faq?  I've read
> the primary PostgreSQL faq?
>
> (3) Using Access/postdrv v6.5 to access my postgresql
> ver 7 database works fine, but I cannot write to it.
> I've turned off both "read only" checkboxes on the
> settings dialog for the driver.  When I enter a value
> into a field, it let's me type it in, but when I try
> to move the cursor away from that field I get the
> error: "ODBC--call failed. Connection is readonly,
> only (#1)".

After you remove all the read only boxes (2 of them?), you need to relink
your tables.  I encountered the same problem... if you make a change to the
ODBC driver, all the tables need to be relinked in Access to notice the
changes.