Unanswered: decimal separator in client access odbc
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.