FIX: DHTML Databound Elements Ignore Regional Settings with RDS (235345)

The information in this article applies to:

Microsoft Internet Explorer (Programming) 4.0
Microsoft Internet Explorer (Programming) 4.01
Microsoft Internet Explorer (Programming) 4.01 SP1
Microsoft Internet Explorer (Programming) 4.01 SP2
Microsoft Internet Explorer (Programming) 5
Remote Data Service for ADO
Remote Data Service for ADO 1.1
Remote Data Service for ADO 1.5
Remote Data Service for ADO 2.0
Remote Data Service for ADO 2.01
Remote Data Service for ADO 2.1
Remote Data Service for ADO 2.1 SP1
Remote Data Service for ADO 2.1 SP2

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.

Modification Type:	Minor	Last Reviewed:	8/19/2005
Keywords:	kbBug kbDataBinding kbDHTML kbfix kbie501fix KB235345