Re: Timestamp column & Access linked ODBC table - Mailing list pgsql-odbc

From Philippe Lang
Subject Re: Timestamp column & Access linked ODBC table
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F420AF86E@poweredge.attiksystem.ch
Whole thread Raw
In response to Timestamp column & Access linked ODBC table  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List 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@tpf.co.jp]
Envoye?: vendredi, 28. novembre 2003 08:12
A?: Philippe Lang
Cc?: pgsql-odbc@postgresql.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

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Timestamp column & Access linked ODBC table
Next
From: Richard Combs
Date:
Subject: Re: Character invalid saving memo with UpdateSQL