From: David Hartwig <daveh@insightdist.com>
To: Matthew <matt@ctlno.com>
Cc: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access can't insert with ODBC connection to PostgreSQL
Date: Sun, 14 Jun 1998 11:25:20 -0400
Message-ID: <3583EB60.CEC2BDA3@insightdist.com> (raw)
References: <A043233669F9D111B99700A0C92376CA151E@srv.ctlno.com>
Matthew wrote:
> Hello, I downloaded the latest ODBC driver for PostgreSQL from
> http://www.insightdist.com/psqlodbc/ version number 06.30.0245. I got
> this driver to work and show data from my database after editing the
> pg_hba.conf file. However, I can't insert new records in the normal
> access way. I can do these inserts when I connect to MS SQL server with
> an ODBC driver in the same manner as above. Is this typical? Or do I
> have something configured wrong? I unchecked both readonly checkboxes
> in the ODBC config, but that had no effect. I was able to do a manual
> insert query by hardcoding it.
>
Access must know a tables key before it will allow updates. Either make
sure "Recognize Unique Indexes" is check (under Driver Options) or manually
specify the key at link time. Oid may be used as a key it it is
checked. In any case you must relink the table to get Access to
recognize the your keys.
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: daveh@insightdist.com, matt@ctlno.com
Subject: Re: [INTERFACES] MS Access can't insert with ODBC connection to PostgreSQL
In-Reply-To: <3583EB60.CEC2BDA3@insightdist.com>
* 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