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

Resolved

  1. How-to
0
Votes
Undo
  1. Kalpana Snehi
    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!

PB2019 - After establishing SQL Native Client conn...
PB 2019 - missing context menu
Responses (2)
Kalpana Snehi
Kalpana Snehi Accepted Answer Pending Moderation
  1. Thursday, 28 November 2019 01:48 AM UTC
  2. PowerBuilder
  3. # 1

Hi Chris;

1) Microsoft SQL Server 2016

2) DB Error - 3997

3) Yes , I did.

Comment
Chris Pollach @Appeon
  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
Kalpana Snehi
  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
Chris Pollach @Appeon
  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.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 28 November 2019 01:24 AM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


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