SqlException Incorrect syntax near ','.

SqlException Incorrect syntax near ','.

Error Message:


TargetInvocationException

Exception has been thrown by the target of an invocation.

SqlException

Incorrect syntax near ','.

at Forecast5.DataAccessLayer.Forecast5Db_SQL2008.Save(IDbTable entity, IEnumerable`1 columns, IEnumerable`1 values)

at Forecast5.DataAccessLayer.Forecast5Db.Save[T](T entity)

at Forecast5.Model.ForecastEntity.Save()

at Forecast5.Model.RegionCollection.Init()

at Forecast5.Model.ForecastEntity.Save()

at Forecast5.Model.RegionCollection..ctor(Node node)


Solution:


This is caused by regional settings not being applicable with Forecast 5.


To fix this, go to Control Panel > Clock and Region: Change date, time, or number formats >  [ Additional settings... ]


The following options must be:

1. Decimal Symbol:     .
2. Digit Grouping Symbol:      ,
3. List Separator:     ,