🚀 go-pugleaf

Hi,


There is a history of misteriously 'damaged' MDAC/ADO under XP/SP2,
so the simple code that uses ADO queries (like this below) fails:

AnsiString TDiMainForm::GetDBVer()
{
   AnsiString Ver = "";

   ADOQuery->Close();
   ADOQuery->SQL->Clear();
   ADOQuery->SQL->Add( "select top 1 * from TblVer" );

   AnsiString CS = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
                   ChangeFileExt( ParamStr(0), C(IDS_SER_MAIN_MDB) ) +
                   ";Mode=Read;Persist Security Info=False";

   ADOQuery->ConnectionString = CS;

   try
   {
      try
      {
         ADOQuery->Open();
         Ver = ADOQuery->FieldValues["Ver"];
      }
      catch ( const Exception &e )
      {
         //ShowMessage( "GetDBVer Error" );
      }
   }
   __finally
   {
      ADOQuery->Close();
   }
   return ( Ver );
}

After lots of investigation, I've found that this is happening because
of settings in Regional and Language Options, which SP2 do not 'like':

SP2 does not like 'Bosnia and Herzegovina' as sufix.

Control Panel > Regional and Language Options > Regional Options

--- Standards and Formats ---
For example, this stops ADO to work: Serbian (Latin, Bosnia and Herzegovina)
Choosing anything other: Serbian (Latin), or English (United States) works.

--- Location ---
Haven't tested, but I suppose that this also has to be corrected.

In other words, this is not desirable for programs that uses ADO:
- Serbian (Cyrillic, Bosnia and Herzegovina)
- Serbian (Latin, Bosnia and Herzegovina)

This is desirable:
- Serbian (Cyrillic)
- Serbian (Latin)

This problem is also known with one version of famous SiSoft Sandra. That's
how I discovered this problem, which I was complaining some time ago.

Who knows how many other new countries has the same problem.




-- 
Best Regards,
Vladimir Stefanovic