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

Re: Help : serious problems with ODBC & Postgresql 7.1 RC2 &Access 2000

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Help : serious problems with ODBC & Postgresql 7.1 RC2 &Access 2000
Date: 2001-04-09 06:16:31
Message-ID: 4.2.2.20010409080819.00a9a9d0@smtp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello all,

Thank you for your quick answers and help.

Surprise : after a discussion with Bill Gates, CIA's most rewarded agent, I 
updated to Jet 4 SP3 which solved all problems.
It seems like MDAC 2.6 and Jet4 SP3 should always be used in conjunction.

Furthermore, I also converted my application to pass-through queries.
Cedar : thanks for your code, I am waiting for it. I will also post mine 
when fully tested.

Greetings from Jean-Michel POURE, Paris

At 08:51 09/04/01 +0900, you wrote:
>Jean-Michel POURE wrote:
> >
> > Hello all,
> >
> > I have serious problems updating an attached table in access 2000.
> > The problem is similar to
> > http://postgresql.rmplc.co.uk/mhonarc/pgsql-odbc/2001-03/msg00020.html
> > My configuration is Access 2000 SP1 / Windows NT SP5 / MDAC 2.6 /
> > PostgreSQL 7.1 RC2 /  7.104 odbc driver
> >
> > 2) Problem description
> >
> > a) When running the query "Select * FROM tblProblematicTable;" inside a
> > form, the record cannot be updated.
> > On the contrary, if running "Select field1, field2, field3, etc .. FROM
> > tblProblematicTable;", the record can be updated.
> > It seems that the maximum number of fields is 8 to 10, no more.
> >
> > b) When deleting 99% of records, updating works again, no matter the number
> > of fields.
> >
> > c) Logs on the client side show nothing.
> > Shall I allow logging server-side ?
> >
>
>Yes. Try running the postmaster with -d2 (and without -S)
>and see what gets logged in its stderr output.
>
>regards,
>Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: Klaus ReimerDate: 2001-04-09 15:13:29
Subject: Connection to a unix domain socket
Previous:From: Hiroshi InoueDate: 2001-04-09 01:16:27
Subject: Re: access #s_c_h#

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