Incorrect import of timestamp fields in MS Access with 7.2.x

From: Edwin Woudt <edwin(at)woudt(dot)nl>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Incorrect import of timestamp fields in MS Access with 7.2.x
Date: 2002-04-16 10:55:53
Message-ID: 2560552730.1018961753@[10.0.1.4]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

After switching from PostgreSQL 7.1.3 to 7.2, I'm having trouble with
timestamp fields in ODBC-linked tables in MS Access (both '97 and XP).

The problem is that MS Access somehow thinks these are 'Text' fields
instead of 'Date/Time' fields. It worked fine when using the 7.1.3 server,
but not with 7.2 and 7.2.1.

I tried different ODBC driver versions, but 7.1.0007, 7.1.0010 and 7.2.0001
all show the same problem.

As this seems to be an ODBC driver related problem, I hope this question is
appropriate on this mailing list. If not, feel free to direct me to another
one.

Edwin

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-04-16 11:07:12 Re: Incorrect import of timestamp fields in MS Access with 7.2.x
Previous Message Will 2002-04-16 10:37:07 unexpected protocol charactor during authentication