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

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 (view raw or flat)
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

pgsql-odbc by date

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

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