IIS Regional Settings
asp.net, globalization, sql-server
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
Problem
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.