DataSet Locale problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have an application that utilizes a dataset. I've found just today, that
if the regional language settings are changed at the point of where I
instantiate the DataSet an error is thrown of: "Cannot add a DataRelation or
Constraint that has different Locale or CaseSensitive settings between its
parent and child tables." The particular dataset in question contains 4
tables. All state that the locale is "English (United States)"

A few things of interest:
1: In three of the four tables the Locale is listed in the properties
bolded, as if it's a default that's been changed. The fourth is in standard
font.
2: Attempting to change any of the locale settings results in a "Propety Is
Not Valid" dialog with details that state: "Cannot change CaseSensitive or
Locale property. This change would lead to at least one DataRelation or
Constraint to have different Locale or CaseSensitive settings between its
related tables."
3: CaseSenstive for all four tables is False
4: If I change the regional settings on my development machine to "Dutch
(Netherlands)" and attempt to load the DataSet in the VS dataset designer,
it won't allow me, stating the same error as when I try to instantiate at
runtime.
5: This is what I think may be the key: The first three tables were added by
dragging from server explorer from an MSDE instance. Then I migrated the
application to SQLExpress and added another table. This table was added by
dragging from the SQL Express instance to the dataset designer. The three
tables that list the Locale property in bold are the tables that were added
from the MSDE instance. The fourth is from the SQLExpress instance.

I have tried removing each of the tables from the dataset and re-adding them
and re-creating the relations, but that doesn't seem to make any difference.

This really has me stumped. Any suggestions?


.

Relevant Pages

  • Re: DataSet Locale problem
    ... or Constraint that has different Locale or CaseSensitive settings between ... All state that the locale is "English " ... or Locale property. ... Constraint to have different Locale or CaseSensitive settings between its ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Ubuntu magic (Karl Larsen)
    ... Locale settings ... How and where can I add a short version of "exit"? ... Have a friend who uses Windows but wants to use Linux. ...
    (Ubuntu)
  • Re: process versus thread
    ... | The locale information is maintained per process, ... | although the script itself never called setlocaleitself. ... windows uses apartment-model threading, where one process is spawned and can ... different settings than another renter...however, different from real life, ...
    (alt.php)
  • Re: Why are there locale troubles under Windows?
    ... of the same process at the same time changing the processwide locale ... thread will have indipendent locale settings_. ... How is PHP supposed to react when someone on the server changes the locale ...
    (comp.lang.php)
  • Re: Versions
    ... I'm not absolutely certain, but doesn't that come with a separately purchased MS Office suite, and is not actually installed or available in Vista itself? ... Cannot anyone, using any version, select any locale he wishes? ... What I meant is a version in which the entire operating system (its various settings and messages and help files and other things) are in UK English. ...
    (microsoft.public.vb.general.discussion)