Error -2147217913 on DataSet Update Locale problem RRS feed

  • Question

  • Here is the problem.
    I have made a DataSet, some data is actually dates, some other are currency, etc. The database is an Access .mdb
    Now in one system runs ok
    In another it fails and throws an OleDbException with the error code: -2147217913: (data type mismatch or something like that)
    I tested both machines and found this:
    The machine where it runs ok has the following configuration in.
    Control Panel ->  Regional and language settings, set to:
    Spanish (Mexico)
    In the one that doesn´t run:
    Spanish (Spain)
    If i change the one that doesnt work to Spanish (Mexico) or English(United States) it works fine.
    Apparently the problem is the way the dataset formats data depending on the language and regional settings specified by windows thus causing the system to fail when configured to Spanish (Spain).

    The main problem is.
    Though there is a work-around through configuration of the system i want to know if there is a way to tell the application to use an specified locale at startup so that every date and every operation made by the dataset is done with that formatting.
    Any help to this problem will be very much appreciated.
    Friday, July 13, 2007 6:01 PM