SAP Data Services Designer displays blank table and column names

  • 12 March 2024
  • 0 replies
  • 12 views

Userlevel 2
Badge

While successfully connecting a provider to SAP Data Services Designer using our CData ODBC Drivers, an issue arises where the table and column names appear blank.

 

This anomaly stems from the tool. The V23 version of our drivers reports the maximum column/table name length as 0 meaning that there is no limit on the length, however, the SAP Data Services Designer treats this as a literal 0 value. 

Solution: Adjust the “Other” connection property to the following value: SqlMaxColumnNameLen=255;SqlMaxTableNameLen=255; 

 

 

 


This topic has been closed for comments