Hi

A silly question, but "PowerBuilder window throws 'database transaction information not available’ error when trying to retrieve" looks like you have not used <datawindow>.settransobject(sqlca) to set up the transaction object for the DW?

Sorry if thsi is nothing to do with your problem.

Regards

David

Hi Gayathri,

Thanks for reporting this issue!
Microsoft doesn’t provide an individual installation package for system.data.sqlclient. It’s usually installed automatically when we install ODBC Driver for SQL Server and SQL Server Management Studio(SSMS). Please refer to the links below:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2016
https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-2016

In addition, PB 2019 R3 supports the MSOLEDBSQL SQL Server driver. We recommend you use MSOLEDBSQL SQL Server. For details, please refer to:
https://docs.appeon.com/pb/whats_new/MS_SQL_Server_enhancements.html

Best Regards,
Peter

Hi Ravi;

   This ADO.net SS driver is something that your DBA Team should provide you as a download from the Microsoft SS DBMS website. Your DBA team should be able to advise you on how to install configure & test it for your SS instance(s).

Regards ... Chris