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