hope this is the right section.

I am extracting data from an AS400 via client access express odbc driver (Windows XP). Apparently the driver is unable to return decimal field values in a consistent way. Actually it misses the decimal separator and return all values as integer, leaving me no option but dividing numbers by 100.

I have already tried and changed the decimal separator setting in odbc driver configuration -> server -> advanced. Nothing happens.

Client access ver is 5 Release 1.

Anyone has experienced the same issue? Thanks in advance for your reply.