SqlException: Incorrect syntax near...
Issue / Error Message:
When trying to import the record list from excel or hotlink to a spreadsheet, the error message below or similar occurs:
SqlException
Incorrect syntax near 's'
Unclosed quotation mark after the character string 'WHERE[1d]=15035'.
Solution:
This is caused if there are any record names with ' (quotes) or " (double quotes) or in the spreadsheet name if hotlinking.
Open the import file in excel and remove any ' (quote) or " (double quote) in the record names.
Then reimport the record list into Forecast 5 or hotlink again.
Related Articles
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 ...Import Error: SQL Exception: Incorrect Syntax near "s"
Issue: Receiving this error message when trying to import records, sections or folders. SQL Exception Incorrect Syntax near "s" Unclosed quotation mark after the character string 'WHERE' This error is caused because there is a single quote character ...SQLException: A network-related or instance-specific error... [Error: 52]
Issue: Forecast 5 cannot continue because of an exception occured: SqlException Solution: This error is generally caused because the Forecast 5 cannot find the SQL Server you are trying to connect to. Please check that your computer can see the SQL ...SQLException: Failed to update database... because the database is read-only
Issue/Error: When opening Forecast 5, you are receiving an error: Forecast5 cannot continue because of an exception occured: SqlException. Failed to update database "[database name]" because the database is read-only. Forecast 5 will fail to open. ...TypeInitializationException: A network-related or instance-specific error... [Error: 26]
Issue: You receive the following error when trying to login to Forecast 5. Forecast 5 cannot continue because of an exception occurred. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified. Cause: This error indicates that ...