INFO: Last Trailing Zero in Numeric Field Truncated with Sybase Database (222120)
The information in this article 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 SP1
- Microsoft Data Access Components 2.5 SP2
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.6 SP1
- 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).
| Modification Type: | Major | Last Reviewed: | 5/10/2003 |
|---|
| Keywords: | kb3rdparty kbDatabase kbinfo KB222120 |
|---|
|