Date Format Problem in SQL

Hi
My Application is designed for 5
languages.English,Spain,France,Japan and Germany.
It works fine for all other 4 languages except France.The
Problem is When Retreiving data from the database i get
an error "Arithmatic Overflow of data of datatype DateTime.
The same Application it works for france in my location
but at the vendor location it fails.we have changed all
the configuration setting(To France Setting(regional
setting and have installed the SQL Server in France as
default language) but still it works fine in our
Location.We have tried running the Application by
replicating their database, we dont face any problem here.
It will be grate ful if you provide solution for this.Is
that in the vendor site they have to install the lastest
service pack version or any thing else to do with the SQL
Server setting in France(because in all other vendor
locations(Spain,Germany,Japan) works fine.Please suggest
some solution for this.
Thanks and Regards,
SumathiHi Sumathi,
I didn't get chance of working on multiple languages.
But, the concept is this:
Installations of localized versions of SQL Server
install the translated set of messages in addition to the
English set. When SQL Server sends a message to a
connection, it uses the localized message if the language
ID of the connection matches one of the language IDs
present in sysmessages. If there is no message in
sysmessages with the same language ID, the English version
of the message is sent.
Please check the "sysmessages" and "syslanguages" and
see whether you have language ID for French.
Also, its always good to keep the all servers with same
service pack level (latest SP3).
Hope this may help you to start with debugging this issue.
Appreciate response if this suggestion helps.
-Varad
>--Original Message--
>Hi
> My Application is designed for 5
>languages.English,Spain,France,Japan and Germany.
>It works fine for all other 4 languages except France.The
>Problem is When Retreiving data from the database i get
>an error "Arithmatic Overflow of data of datatype
DateTime.
>The same Application it works for france in my location
>but at the vendor location it fails.we have changed all
>the configuration setting(To France Setting(regional
>setting and have installed the SQL Server in France as
>default language) but still it works fine in our
>Location.We have tried running the Application by
>replicating their database, we dont face any problem
here.
>It will be grate ful if you provide solution for this.Is
>that in the vendor site they have to install the lastest
>service pack version or any thing else to do with the SQL
>Server setting in France(because in all other vendor
>locations(Spain,Germany,Japan) works fine.Please suggest
>some solution for this.
>Thanks and Regards,
> Sumathi
>.
>