From: Byron Nikolaidis <byronn@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 14:57:50 -0400
Message-ID: <35841D2D.7EEFC440@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.
>
In addition to the datasource not being read-only, Access requires a unique
identifier to be able to update any records. The driver, by default, does
not report unique identifiers automatically. Either you must enable the
"recognize unique indexes" advanced driver option OR, if you are using
Access 95 or 97, you can manually select the unique identifier while linking
the table.
Hope that helps.
Byron
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: byronn@insightdist.com, matt@ctlno.com
Subject: Re: [INTERFACES] MS Access can't insert with ODBC connection to PostgreSQL
In-Reply-To: <35841D2D.7EEFC440@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