470,810 Members | 888 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

MS-Access and IBM DB2 ODBC driver

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

Oct 16 '06 #1
0 1197

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Christian McArdle | last post: by
18 posts views Thread by Rob R. Ainscough | last post: by
1 post views Thread by Dr T | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.