Article ID: 222120 - Last Review: May 10, 2003 - Revision: 2.1

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

This article was previously published under Q222120
Expand all | Collapse all

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).

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
Keywords: 
kb3rdparty kbdatabase kbinfo KB222120
 

Article Translations