Resolved

0
Votes
Undo
  1. Kalpana Snehi
  2. PowerBuilder
  3. Thursday, 28 November 2019 01:12 AM UTC

We have migrated PB12.5 to pb2019 and we are using sql native client for 64 bit as our old OLE DB is not supported by appeon. But after successful migration and connectivity. we are getting error in saving data back to sql server, getting information message that transactiob begin but after that its not saving anything. I debug and found that its actually not getting no pending updates. Kindly help!

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 28 November 2019 01:24 AM UTC
  2. PowerBuilder
  3. # 1

Hi Kalpana;

1) What version of SS are you using?

2) Can you post the actual DB Error Code & Error Text?

3) Have you run an SQL Trace?

  ie: SQLCA.DBMS. =. "Trace SNC"

Regards ... Chris

Comment
There are no comments made yet.
Kalpana Snehi Accepted Answer Pending Moderation
  1. Thursday, 28 November 2019 01:48 AM UTC
  2. PowerBuilder
  3. # 2

Hi Chris;

1) Microsoft SQL Server 2016

2) DB Error - 3997

3) Yes , I did.

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 28 November 2019 02:08 AM UTC
Ahhh ... Looks like your issue is with the SS MARS feature. MARS is "on" by default in the SNC driver. Try turning the SS feature off, as follows:



SQLCA.DBParm = "ProviderString='MARS Connection=FALSE;'"



HTH
  1. Helpful
  1. Kalpana Snehi
  2. Friday, 29 November 2019 15:38 PM UTC
Thanks Chris, It worked, It was there in INI but under Provider so I moved it in ProviderString.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 29 November 2019 18:09 PM UTC
Hi Kalpana;

That is great news!

Thanks for letting us know that this solved your issue. ;-)

Regards ... Chris
  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.