Re: Timestamp column & Access linked ODBC table

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Timestamp column & Access linked ODBC table
Date: 2003-11-28 07:24:01
Message-ID: 6C0CF58A187DA5479245E0830AF84F420AF86E@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

It works great, thanks a lot for the solution, and for the ODBC driver by the way, which works really fine.

Philippe Lang

-----Message d'origine-----
De?: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Envoye?: vendredi, 28. novembre 2003 08:12
A?: Philippe Lang
Cc?: pgsql-odbc(at)postgresql(dot)org
Objet?: Re: [ODBC] Timestamp column & Access linked ODBC table

Philippe Lang wrote:
>
> Hello,
>
> As soon as there is a timestamp column in a Postgresql table,
> it's impossible to update it through an Access ODBC link. I'm
> not the first one to face this problem, but does anyone have
> a definitive explanation, or maybe workaround?

Timestamp means timestamp(6) which Access couldn't handle
properly. Please use timestamp(0) instead.

regards,
Hiroshi Inoue

Browse pgsql-odbc by date

  From Date Subject
Next Message Richard Combs 2003-11-28 07:45:27 Re: Character invalid saving memo with UpdateSQL
Previous Message Hiroshi Inoue 2003-11-28 07:11:54 Re: Timestamp column & Access linked ODBC table