Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

(216879) - Using Microsoft OLEDB Provider for AS/400 and VSAM, a zoned decimal type on an OS/390 host may not be converted correctly to either string, numeric, or decimal automation types on the client. The following information is contained in the err...

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 216879 - Last Review: November 24, 2004 - Revision: 2.1

BUG: 'Errors occurred' Results When Converting OS/390 Signed Zoned Decimal Field

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q216879

SYMPTOMS

Using Microsoft OLEDB Provider for AS/400 and VSAM, a zoned decimal type on an OS/390 host may not be converted correctly to either string, numeric, or decimal automation types on the client. The following information is contained in the err structure:

Source: Provider
Number: -2147217887 (0x80040E21)
Description: Errors occurred
The zoned decimal type is determined in the Host Column Description (HCD) file using the product's Microsoft Management Console snap-in for administration. To specify the zoned decimal type for a particular host column, its 'Host Type' property is set to 'Zoned'.

If the low order byte of the host variable indicates a "+" or "-" sign, data conversion fails.

If the low order byte indicates no sign, that is, the absolute value, conversion works correctly.
Back to the top

WORKAROUND

Use 'Character' instead of 'Zoned' for the 'Host Type' property. Specify the automation type as 'DBTYPE_STR'. Determine the sign and value of the low order byte programatically.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top
APPLIES TO
  • Microsoft OLE DB Provider for AS/400 and VSAM 1.0
  • Microsoft OLE DB Provider for AS/400 and VSAM 4.0 SP2
Back to the top
Keywords: 
kbbug kbpending KB216879
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting