MS-Access and IBM DB2 ODBC driver

[maha]

Hi guys,

I've had a problem with the DECIMAL data type when using the ODBC
driver. I've found a workaround and want to share it, as the
information on this topic are sparse.

When querying a DB2 database via ODBC (using Microsoft Access 2003 /
German version) there occures the error that all "trailing numbers"
(e.g. '12' in 150,12) of DECIMAL fields are being interpreted as part
of the number, that is 15012 (note: in German the separator is a ','
instead of a '.').

Workaround: Cast the data type to FLOAT in your query.
E.g.: SELECT LINEITEMS.ITEM, FLOAT(LINEITEMS.AMOUNT) FROM LINEITEMS

Yours,
Markus