From: Roland Dirlewanger <rd@dr15.cnrs.fr>
To: pgsql-interfaces@postgresql.org
Subject: problems with Insight's ODBC driver and Access 97
Date: Mon, 07 Sep 1998 10:09:49 +0300
Message-ID: <199809070809.KAA00651@leopardi.dr15.cnrs.fr> (raw)
We have a Postgres 6.3.2 database on Linux 2.0.32/RedHat 5.0. We configured
Microsoft Access 97 on NT 4.0 workstation and the PostSQL ODBC driver from
Insight to query the database.
There's no problem to link a Postgres table in Access 97 and consult the
database.
On the other hand, if we modify a value from Access 97, Access blocks forever.
The last string I got in the log file is :
query='UPDATE "table1" SET "id"='CIE' WHERE "nogcf" = 'xxx' AND "id" = '' AND
"raison" = 'xxx ''
I tried with Openlink's PostgresSQL and the same configuration : both read and
write requests work.
Does someone knows what I'm doing wrong with Insight's PostSQL ODBC ?
Thanks a lot in advance.
Roland.
--
Roland Dirlewanger
CNRS - Délégation Aquitaine et Poitou-Charentes
Esplanade des Arts et Métiers
33402 TALENCE CEDEX
Mél : rd@dr15.cnrs.fr, Tél : 05 56 37 80 80, Fax : 05 57 96 10 56
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: rd@dr15.cnrs.fr
Subject: Re: problems with Insight's ODBC driver and Access 97
In-Reply-To: <199809070809.KAA00651@leopardi.dr15.cnrs.fr>
* 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