After updating to a new version of Troika, you may see an error accessing Troika:
Troika Startup Autoexec ODBC- Update on a linked table
The error states:
Start Up Autoexec ODBC- Update on a linked TBLCONTACT failed. ODBC SQL Server Driver MERGE failed because the following SET options have incorrect settings: CONCAT_NULL_YIELDS, ANSI WARNINGS. Verify that SET options are correct for the use with indexed views and indexes on computed columns and .or filtered indexes and/or query notification.
This error can be caused by not checking the following options when creating an ODBC DSN data source to the Troika SQL Database:
- Use ANSI quoted identifiers.
- User ANSI nulls, paddings and warnings.
You should amend the DSN and check these settings.
Re-select the DSN from the Troika Desktop once the DSN has been reconfigured, by right clicking on the Troika Desktop in the system tray and choosing DSN > Select DSN.