ADO, ShortDateFormat and Terminal Services/Citrix

I have a customer that is serving my application over Terminal Services and
another on Citrix.

They want to give individual users different date formats (D/M/YYYY or
M/D/YYYY). They implemented a REG file that updates the date format when
the profile starts up. From a display point of view, it works perfectly.

The problem is when ADO uses localized filtering, it gets the day and months
values swapped. It's like the ShortDateFormat that my app uses is different
than the one that ADO uses.

Does anyone know how ADO figures out the ShortDateFormat?


.

Relevant Pages

  • Re: ADO, ShortDateFormat and Terminal Services/Citrix
    ... They want to give individual users different date formats (D/M/YYYY or ... than the one that ADO uses. ... Does anyone know how ADO figures out the ShortDateFormat? ... Sh.RegWrite iDatePath, iDateFormat ...
    (borland.public.delphi.database.ado)
  • ADO, ShortDateFormat and Terminal Services/Citrix
    ... Regional setting changes update the same reg keys. ... The problem is when ADO uses localized filtering, it gets the day and months ... It's like the ShortDateFormat that windows and my app uses ... Does anyone know how ADO figures out the ShortDateFormat? ...
    (borland.public.delphi.database.ado)
  • Re: ShortDateFormat Problem
    ... ShortDateFormat:= 'ddmmyy'; ... types: 'Char' and 'string' ... if I set the DateSeparator and the TimeSeparator to '0': ... Use the correct date & time formats. ...
    (comp.lang.pascal.delphi.misc)
  • Re: ADO, ShortDateFormat and Terminal Services/Citrix
    ... uses is different than the one that ADO uses. ... It's a mistake to have varying date formats. ... should be provided controls (calendar controls) to allow them to supply ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Which is the best single-user DB ?
    ... Keep in mind that you can access many local DB formats using ADO ... controls and the Microsoft drivers included with Windows. ...
    (borland.public.delphi.thirdpartytools.general)