By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

MS-Access and IBM DB2 ODBC driver

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.