Accounting 2.0 - Prompted Message: Error upgrade to 2.1 – Unknow Sql Exception (Number=195, Message=’CONCAT’..)

Question: When upgrading Autocount Accounting from 1.9 to 2.1, it prompted the error message: Unknown Sql Exception (Number = 195, Message=’CONCAT’ is not a recognized built – in function name.)

Version: 2.1

Possible Reason:

Your SQL Server version might be lower than SQL 2012. This 'CONCAT' is a SQL query syntax that only support starting SQL 2012.

Solution:

Upgrade the current SQL Server to SQL Server to 2012 or above.

Then re-login to upgrade database again.

By: Soh Wee 240625, Lay Swan 240729, Jae Sen 240805

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note AutoCount Accounting 2.2 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations