ADO, ShortDateFormat and Terminal Services/Citrix

I am using D7.1, MDAC 2.8 and SQL Server 2005.

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. Regional setting changes update the same reg keys.
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 windows and my app uses
is different
than the one that ADO uses.

Does anyone know how ADO figures out the ShortDateFormat? Is this a setting
I can update when my app starts like ADOShortDateFormat = ShortDateFormat or
something like that.

The problem doesn't occur on a normal (non-thin client) installation.


.

Relevant Pages

  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • Re: Run ADO/OLE DB from a CD-R
    ... using ADO/OLE Db from a CD. ... I need to get my VB6 app. ... also have had Visual Studio installed, however on all other machines, the ADO ... I've tried to include all possible files on the CD (MDAC, ADO, Jet, etc etc) ...
    (microsoft.public.data.ado)
  • Re: DataGrid, DataBinding, ... help!
    ... I'm not using ADO. ... ADO is not the backend database engine, it is a data access layer that ... interprets between your app and that backend. ...
    (microsoft.public.vb.general.discussion)
  • install/deploy c# app
    ... My app includes CDO and ADO. ... name ADODB, or one of its dependencies, was not found. ... I also tried adding a setup project but it failed due to FxMdac Pugin ...
    (microsoft.public.dotnet.framework.setup)
  • install/deploy c# app
    ... My app includes CDO and ADO. ... name ADODB, or one of its dependencies, was not found. ... I also tried adding a setup project but it failed due to FxMdac Pugin ...
    (microsoft.public.dotnet.csharp.general)