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

Resolved Native Client for SQL Server (SNC)

  1. Issue
0
Votes
Undo
  1. Steve Mason
    Steve Mason
  2. PowerBuilder
  3. Friday, 22 June 2018 20:09 PM UTC

I am attempting to change a Powerbuilder 2017 R2 application that works using OLE to use the SQL Native Client for SQL Server interface
(SNC).  The database is SQL Server 2008 R2.

The connection parameters are:
dbms=snc
logid=ertransfer
logpassword=<*************>
servername=QUADRAS30\Q30SQL2008
dbparm="Provider='SQLNCLI10',TrustedConnection=0,Database='QRecordDev',appname='ERRD 3.6.1',host='QUADRAS30'"

The program successfully connects to the database and calls multiple stored procedures.  When the program executes the following statements
as_SQLStatement = 'begin transaction'
execute immediate :as_SQLStatement using this;

the following error occurs:
sqldbcode = 3997
sqlerrtext = SQLSTATE = 42000  Microsoft SQL Server Native Client 10.0  A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back.

Do I need different connection parameters?

 

 

  1. PowerBuilder
Intellisense not working
Power Server Web Java Web Application Maintainabil...
Responses (2)
Chris Harmon
Chris Harmon Accepted Answer Pending Moderation
  1. Tuesday, 26 June 2018 06:25 AM UTC
  2. PowerBuilder
  3. # 1

MARS is on by default for SQL Serve connections. You need to add the following to your DBPam on the transaction:

ProviderString='MARS Connection=FALSE;'

Hope you get it working

Chris

Comment
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Friday, 22 June 2018 20:28 PM UTC
  2. PowerBuilder
  3. # 2

Hi Steve,

Are you using SQLCA.Autocommit = true?

You don't need BEGIN/END tran when  Autocommit = false.

HTH /Michael

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