1. Praburaj KarthiKeyan
  2. PowerBuilder
  3. Thursday, 23 December 2021 13:49 PM UTC

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 .

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 December 2021 15:16 PM UTC
  2. PowerBuilder
  3. # 1

Hi Praburaj;

   FWIW: The "OLE-DB" DB driver is now deprecated MS-SQL Server wise (Microsoft wise). I would try using the new SS DB driver that can be instantiated from PB by the following ...

SQLCA.DBMS = "MSO" 

That provider is also much faster.

HTH

Regards ... Chris

Comment
  1. Praburaj KarthiKeyan
  2. Sunday, 26 December 2021 04:19 AM UTC
Hi Chris, "MSO" is not supported , I am using DBMS=SQLServer (OLEDB)
  1. Helpful
  1. Chris Pollach @Appeon
  2. Sunday, 26 December 2021 04:58 AM UTC
You must have an older PB version then.

Instead, try the SS native driver...

SQLCA.DBMS = "SNC"
  1. Helpful
  1. Miguel Leeuwe
  2. Sunday, 26 December 2021 08:00 AM UTC
Like Chris said, you might be using an older version of PB or ... maybe this note could clarify things:

"MSO" is the same as "MSOLEDBSQL SQL Server"

regards
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 December 2021 16:18 PM UTC
  2. PowerBuilder
  3. # 2

What version is your SQL Server?  Your driver looks way too old.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.