FIX: ODBC Driver for DB2 Maps DATE Fields to Text When You Link a Table from Access (326811)
The information in this article applies to:
- Microsoft Host Integration Server 2000
This article was previously published under Q326811 SYMPTOMS
When you use Microsoft ODBC Driver for DB2 to link a table from
Microsoft Access (all versions), you may get incorrect values when the
selected fields are defined as DATE data type fields.
CAUSE
The Microsoft ODBC Driver for DB2 is returning a
SQL_TYPE_DATE,TIME,TIMESTAMP data type.
This data type is not known by Microsoft Access (all versions), because
Access is only ODBC 2.0 compliant. Microsoft Access maps this data type
to the default data type TEXT.
RESOLUTIONHost Integration Server 2000To resolve this problem, obtain the latest service pack for Host Integration Server 2000. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
328152 How to Obtain the Latest Host Integration Server 2000 Service Pack
The English version of this fix has the file attributes (or later) that
are listed in the following table. The dates and times for these files
are listed in coordinated universal time (UTC). When you view the file
information, it is converted to local time. To find the difference
between UTC and local time, use the Time Zone tab in the Date
and Time tool in Control Panel.
Date Time Version Size File name
---------------------------------------------------------
21-Jun-2002 17:13 5.0.0.866 880.912 Mseidb2d.dll
NOTE: Because of file dependencies, the most recent fix that
contains the preceding files may also contain additional files.
STATUSMicrosoft has confirmed that this is a problem in Host Integration Server 2000. This problem was first corrected in Host Integration Server 2000 Service Pack 1.
| Modification Type: | Minor | Last Reviewed: | 3/25/2005 |
|---|
| Keywords: | kbBug kbfix kbHostIntegServ2000preSP1fix kbHostIntegServ2000SP1fix KB326811 |
|---|
|