Skip site navigation (1) Skip section navigation (2)

problems with Insight's ODBC driver and Access 97

From: Roland Dirlewanger <rd(at)dr15(dot)cnrs(dot)fr>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: problems with Insight's ODBC driver and Access 97
Date: 1998-09-07 07:09:49
Message-ID: 199809070809.KAA00651@leopardi.dr15.cnrs.fr (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)dr15(dot)cnrs(dot)fr, Tél : 05 56 37 80 80, Fax : 05 57 96 10 56



Responses

pgsql-interfaces by date

Next:From: David HartwigDate: 1998-09-07 13:52:43
Subject: Re: [INTERFACES] problems with Insight's ODBC driver and Access 97
Previous:From: Gerald FischerDate: 1998-09-05 23:47:39
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group