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?