BUG: Access Driver Returns Incorrect pcbValueLast reviewed: September 9, 1996Article ID: Q106480 |
The information in this article applies to:
BUG# ODBCDBASE: 1858 (1.01.1928)
SYMPTOMSThe ODBC Access driver returns incorrect pcbValue when a column with the ODBC SQL type SQL_TIMESTAMP is converted to SQL_C_DATE via SQLBindCol or SQLGetData. The following assumes that there is a table called DATETEST in which column number 2 is a column of type datetime:
- SQLExecDirect the statement: select * from DATETEST - Do a SQLBindCol on col #2 so that fCType is SQL_C_DATE. - Do a SQLFetch. - Examine the value of *pcbValue.It will be 10; while the expected =6. The same (invalid) pcbValue is returned if, instead of SQLBindCol, data is retrieved through SQLGetData with fCType = SQL_C_DATE. Correct pcbValue is returned when fCType = SQL_C_TIME.
STATUSMicrosoft has confirmed this to be a problem in the Access Driver version 1.01.1928. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |