I am using MS SQL .
Error -- > UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
// Profile xxxx
SQLCA.DBMS = "OLE DB"
SQLCA.LogId = "xxxxx"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='xxxxxxx',PROVIDERSTRING='database=xxx',OJSyntax='PB'"
I tryed in my INI file DBParM "IdentifierQuoteChar='" and DelimitIdentifier='Yes' ,BUT still Error .
Instead, try the SS native driver...
SQLCA.DBMS = "SNC"
"MSO" is the same as "MSOLEDBSQL SQL Server"
regards