Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved UPDATE failed - QUOTED_IDENTIFIER

  1. Issue
0
Votes
Undo
  1. Praburaj KarthiKeyan
    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 .

 

Merry Christmas!
Installing in Silent - Setup folder for PBRT
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 December 2021 16:18 PM UTC
  2. PowerBuilder
  3. # 1

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

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 December 2021 15:16 PM UTC
  2. PowerBuilder
  3. # 2

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
Praburaj KarthiKeyan
  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
Chris Pollach @Appeon
  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
Miguel Leeuwe
  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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.