Symptom

You may encounter the following error message running an UPDATE statement:

[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.

Environment

  • PowerBuilder
  • Microsoft SQL Server 2008 R2

Resolution

Execute the following statementsbeforethe UPDATE call:

EXECUTE IMMEDIATE "SET QUOTED_IDENTIFIER ON" USING SQLCA;

EXECUTE IMMEDIATE "SET ARITHABORT ON" USING SQLCA;

See Also

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms175088(v=sql.105)

1
2