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

 http://msdn.microsoft.com/en-us/library/ms175088.aspx

0
1