Decimal Separator problem with IIS in Windows 2000 Server .
Posted on 2003-10-24
I am Using IIS 5.0 in Windows 2000 in order to deploy an ASP Web Site . I have a problem when my ASP pages make some calculations and return a decimal value . The decimal value returned has a comma (,) as the decimal separator . I have the regional settings configured as follows:
- decimal separator (.)
- thousand separator (,)
I even made a little program in vbasic to test decimal calculations and It works fine with the regional settings , It changes between comma and dot(.) if my regional settings are changed.
I tested some decimal calculations in the sql server and they work fine and SQL Server retrieves and stores data according to the operating system regional settings .
I even made changes in the sDecimal key in registry .
So I conclude the problem is IIS , How can I make IIS to show the same format for decimal numbers as in regional settings ?
Ps. Another Thing : In NT 4.0 everything works fine .
thank you for your help .