Microsoft KB Archive/222120

= INFO: Last Trailing Zero in Numeric Field Truncated with Sybase Database =

Article ID: 222120

Article Last Modified on 5/10/2003

-

APPLIES TO


 * Microsoft Data Access Components 1.5
 * Microsoft Data Access Components 2.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.5 Service Pack 1
 * Microsoft Data Access Components 2.5 Service Pack 2
 * Microsoft Data Access Components 2.6
 * Microsoft Data Access Components 2.6 Service Pack 1
 * Microsoft Data Access Components 2.7

-



This article was previously published under Q222120



SUMMARY
While using ADO to access a Sybase database table using an ADO server-side cursor (adUseServer), the last trailing zero in a numeric field is truncated. This happens while accessing the Sybase database through the Microsoft OLE DB provider for ODBC using the Intersolv 3.11 32-bit Sybase ODBC driver (3.11.00.0).



MORE INFORMATION
To avoid the truncation, use ADO's client-side cursor (adUseClient).

Keywords: kbinfo kbdatabase kb3rdparty KB222120

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.