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

ID: Q222120

The information in this article applies to:

Microsoft Data Access Components versions 1.5, 2.0

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

Additional query words:


Keywords          : kb3rdparty kbDatabase kbMDAC kbODBC kbOSP kbGrpVCDB kbGrpMDAC 
Version           : WINDOWS:1.5,2.0
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: May 7, 1999