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 EAA17619 for ; Tue, 8 Sep 1998 04:28:35 -0400 (EDT) Received: from leopardi.dr15.cnrs.fr by camus.dr15.cnrs.fr; Tue, 8 Sep 1998 10:28:32 +0200 (MET DST) X-Url: http://www.dr15.cnrs.fr Received: from leopardi.dr15.cnrs.fr by leopardi.dr15.cnrs.fr; Tue, 8 Sep 1998 10:28:44 +0200 Message-Id: <199809080828.KAA00689@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: no more problems with Insight's ODBC driver and Access 97 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Date: Tue, 08 Sep 1998 10:28:44 +0300 From: Roland Dirlewanger Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by leopardi.dr15.cnrs.fr id KAA00689 Yesterday, I sent to the list the following request : > > 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. Many thanks to all of those who answered my question, either directly to me or on the list. The solution is to change the [Use Declare/Fetch] option to false, on the Post SQL ODBC driver configuration. Everything works well know. 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