Microsoft KB Archive/235345

= FIX: DHTML Databound Elements Ignore Regional Settings with RDS =

Article ID: 235345

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Internet Explorer 4.0 128-Bit Edition
 * Microsoft Internet Explorer 4.01 Service Pack 2
 * Microsoft Internet Explorer 4.01 Service Pack 1
 * Microsoft Internet Explorer 4.01 Service Pack 2
 * Microsoft Internet Explorer 5.0
 * Microsoft Plus! Game Pack: Cards & Puzzles
 * Microsoft Remote Data Services 1.1
 * Microsoft Remote Data Services 1.5
 * Remote Data Service for ADO 2.0
 * Microsoft Remote Data Services 2.0
 * Microsoft Remote Data Services 2.1
 * Microsoft Remote Data Services 2.1
 * Microsoft Remote Data Services 2.1

-



This article was previously published under Q235345



SYMPTOMS
When using Dynamic HTML (DHTML) databinding, elements databound to the RDS data source object do not appear with the proper regional settings on non-English installations of Windows. For example, the date January 20,1999, shows in the databound control with the format "1/20/1999," even on a German Windows NT machine that has the date format set to "20.01.99."



CAUSE
DHTML databinding delegates all type conversions and data formatting to the data source provider. RDS uses the standard OLE-DB type conversion library, which unfortunately ignores regional settings.



RESOLUTION
The only alternative is to databind procedurally to the datasource and do all the necessary type conversions programmatically. That is, script on the page needs to retrieve the Recordset directly from RDS, obtain the data, re-format it as desired, and then set that data into the proper page elements.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in Internet Explorer 5.01.

Keywords: kbbug kbfix kbie501fix kbdatabinding kbdhtml KB235345

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.