Received: from camus.dr15.cnrs.fr (camus.dr15.cnrs.fr [147.210.72.192]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA16678 for ; Mon, 7 Sep 1998 04:09:40 -0400 (EDT) Received: from leopardi.dr15.cnrs.fr by camus.dr15.cnrs.fr; Mon, 7 Sep 1998 10:09:38 +0200 (MET DST) X-Url: http://www.dr15.cnrs.fr Received: from leopardi.dr15.cnrs.fr by leopardi.dr15.cnrs.fr; Mon, 7 Sep 1998 10:09:50 +0200 Message-Id: <199809070809.KAA00651@leopardi.dr15.cnrs.fr> X-Mailer: exmh version 2.0zeta 7/24/97 Organization: CNRS, Delegation Aquitaine et Poitou-Charentes, Bordeaux, France. To: pgsql-interfaces@postgresql.org Subject: problems with Insight's ODBC driver and Access 97 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Date: Mon, 07 Sep 1998 10:09:49 +0300 From: Roland Dirlewanger Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by leopardi.dr15.cnrs.fr id KAA00651 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