Re: NUMERIC type makes trouble in MS Access

From: "Tobias Wendorff" <tobias(dot)wendorff(at)tu-dortmund(dot)de>
To: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
Cc: "Craig Ringer" <craig(at)2ndquadrant(dot)com>, "Jan Wieck" <jan(at)wi3ck(dot)info>, pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: NUMERIC type makes trouble in MS Access
Date: 2018-05-29 00:34:38
Message-ID: e555509c68fd476f3e868150fa00e54d.squirrel@webmail.tu-dortmund.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Hiroshi,

Am Di, 29.05.2018, 00:39 schrieb Inoue, Hiroshi:
> The modified drivers should extend the field length to
> "max varchar" size. Please test the driver and tell me the result.

Oops, I didn't see a change in version number and thought it was the
same build.

Sorry, it does NOT work. I've set "max varchar" to 250, but the column
in Access still has a width of 28. I've uninstalled and re-installed
the driver and I've set up a fresh DSN for testing.

Also, there's another bug: When relinking the table from Access'
tablemanager, the column type suddenly gets changed to double
(without having anything changed in the ODBC driver). It's exactly
the same table. There's no way to revert this :(

Best regards,
Tobias

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Tobias Wendorff 2018-05-29 00:43:49 Re: NUMERIC type makes trouble in MS Access
Previous Message Inoue, Hiroshi 2018-05-28 22:39:47 Re: NUMERIC type makes trouble in MS Access