Client Access Dropping Decimals when Downloading

1720 pts.
Tags:
iSeries AS400 Client Access transfer download ADO ODBC
Numeric fields are missing decimals when downloaded from iSeries using ADO. The culprit appears to be V7 of IBM i Access. The problem machine's version for CWBODBC.DLL is 13.00.01.00 We've tested the same code on other Win Pro 7 64 bit machines w/o issue. They are using version 11.64.00.00. The problem machine can download via DSN w/o issue. Is there a setting I'm missing to have numeric data w/decimals passed as decimal data instead of integer data?

Software/Hardware used:
iSeries AS400 Clien Access ADO

Answer Wiki

Thanks. We'll let you know when a new response is added.

Wow! It’s hard to imagine that this went all this time without being answered.

Cause:
Client Access 7.1 needs service pack SI45664
Download at: http://www-03.ibm.com/systems/power/software/i/access/windows_sp.html

NOTE! Before applying sevice pack SI45664, we must apply a security patch to Windows 7. That can be downloaded here: http://www.microsoft.com/en-us/download/details.aspx?id=26347

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Somewhere back around then, the site became almost unusable. I know that I totally stopped visiting for a while. Changes in later months brought the site back somewhat, though more changes are needed and apparently are coming. Good point, though, that there might be numerous open questions from that period that need review. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following