pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems with Insight's ODBC driver and Access 97
2+ messages / 2 participants
[nested] [flat]
* problems with Insight's ODBC driver and Access 97
@ 1998-09-07 07:09 Roland Dirlewanger <rd@dr15.cnrs.fr>
0 siblings, 1 reply; 2+ messages in thread
From: Roland Dirlewanger @ 1998-09-07 07:09 UTC (permalink / raw)
To: 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@dr15.cnrs.fr, Tél : 05 56 37 80 80, Fax : 05 57 96 10 56
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] problems with Insight's ODBC driver and Access 97
@ 1998-09-07 13:52 David Hartwig <daybee@bellatlantic.net>
parent: Roland Dirlewanger <rd@dr15.cnrs.fr>
0 siblings, 0 replies; 2+ messages in thread
From: David Hartwig @ 1998-09-07 13:52 UTC (permalink / raw)
To: Roland Dirlewanger <rd@dr15.cnrs.fr>; +Cc: 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@dr15.cnrs.fr, Tél : 05 56 37 80 80, Fax : 05 57 96 10 56
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-09-07 13:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-07 07:09 problems with Insight's ODBC driver and Access 97 Roland Dirlewanger <rd@dr15.cnrs.fr>
1998-09-07 13:52 ` David Hartwig <daybee@bellatlantic.net>
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