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

Re: [INTERFACES] problems with Insight's ODBC driver and Access 97

From: David Hartwig <daybee(at)bellatlantic(dot)net>
To: Roland Dirlewanger <rd(at)dr15(dot)cnrs(dot)fr>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] problems with Insight's ODBC driver and Access 97
Date: 1998-09-07 13:52:43
Message-ID: 35F3E52A.5E058A11@bellatlantic.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
I am at home and I don't remember the exact terminology, but you need to turn on
(or turn off) the declare/fetch in one of the advanced option dialogs.    I know I
sound unsure of myself, but trust me on this one.   I not fully awake yet.

Byron, this option should be defaulted in the other direction with the next
release.

Roland Dirlewanger wrote:

> 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


In response to

pgsql-interfaces by date

Next:From: Aleksey V. MeledinDate: 1998-09-07 14:51:46
Subject: Can you help me?
Previous:From: Roland DirlewangerDate: 1998-09-07 07:09:49
Subject: problems with Insight's ODBC driver and Access 97

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