PowerBuilder Troubleshooting Guide
Database

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

Solution

Execute the following statements before the 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