1. Gayathri Ravi
  2. PowerBuilder
  3. Tuesday, 25 June 2024 22:14 PM UTC

PowerBuilder window throws 'database transaction information not available’ error when trying to retrieve. We are using ADO.NET as DBMS type and Namespace is system.data.sqlclient for SQL connection. Could you please tell me how to resolve the error? And where can I find the installation file for '.NET Framework Data Provider for SQL Server'?

 

We believe this is a driver related issue as it is working on some machines without any issue.

 

 

Attached the error details. 

David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2024 14:48 PM UTC
  2. PowerBuilder
  3. # 1

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

Comment
There are no comments made yet.
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2024 02:11 AM UTC
  2. PowerBuilder
  3. # 2

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

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2024 00:07 AM UTC
  2. PowerBuilder
  3. # 3

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 

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.