pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roland Dirlewanger <rd@dr15.cnrs.fr>
To: pgsql-interfaces@postgreSQL.org
Subject: no more problems with Insight's ODBC driver and Access 97
Date: Tue, 08 Sep 1998 10:28:44 +0300
Message-ID: <199809080828.KAA00689@leopardi.dr15.cnrs.fr> (raw)


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





Message-ID: <199809080828.KAA00689@leopardi.dr15.cnrs.fr>
Permalink:  ../199809080828.KAA00689@leopardi.dr15.cnrs.fr/
Also on:    postgresql.org/message-id/199809080828.KAA00689@leopardi.dr15.cnrs.fr

 · 

reply

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: no more problems with Insight's ODBC driver and Access 97
  In-Reply-To: <199809080828.KAA00689@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