SAP Knowledge Base Article - Preview

2138786 - SQL Server Text DataType Issue with SNC driver - SAP PB

Symptom

  • Application migrated from Sybase PowerBuilder 9.02 to SAP PowerBuilder 12.5.2 connecting to MS SQL Server. 
  • In Sybase PowerBuilder 9.02, the application used the MSS driver and in SAP PowerBuilder 12.5.2 using the SNC driver.
  • A datawindow references a stored procedure that returns a text datatype that now in PowerBuilder 12.5.2 does not display the value unless the datatype is 32767.  
  • The datawindow returns a char(1000). 
  • This worked in PowerBuilder 9.02.  In order to make the code return a value we would have to modify hundreds of data windows changing the datatype on each

Note, this issue appears to affect XML and varchar(max) datatypes as well.


Read more...

Environment

  • SAP PowerBuilder 12.5.2
  • SAP PowerBuilder 12.6
  • MS SQL Server

Product

PowerBuilder all versions ; SAP PowerBuilder all versions

Keywords

pb,snc,mss,staticbind,text,sp,staticbind=0,NoCheckNullBind=1,datatype , KBA , BC-SYB-PB , PowerBuilder , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.