Search code examples
asp.netsql-serverglobalization

IIS Regional Settings

My asp.net website locally uses dots as decimal separator (100.55), on my deployment server the SQL Server uses dots as separators, but the Asp.net website changes it to a comma (100,55)

Now the problem I am having is that when I try top do an update from the website the SQL query fails (because of the comma). First I thought ok easy, change regional settings and restart website. That didn't work, so I restarted the server, that didn't work either. Then I changed the .NET Globalization Settings, which also didn't work.

I have SQL Server 2012 and IIS 8.

Solution

  • go to this link and change your IIS setting for Your website:

    Edit .NET Globalization Settings (IIS 7)

    this works for IIS 8. you must change Culture and UICulture and set enableClientBasedCulture True