thewealthworks Customer Support Portal

I'm getting an Error accessing Troika, after updating to a new version of 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.