SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 63485: Only the first letter of a table name shows when you use SAS® Data Connector to ODBC and SAS® Data Connector to SQL Server

DetailsHotfixAboutRate It

Only the first letter of the table name is displayed when you list tables from an ODBC library and the following conditions are true:

  • SAS® Viya® is configured to use SAS Data Connector to SQL Server.
  • You are also using SAS Data Connector to ODBC to connect to another database.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

When using SAS Data Connector to ODBC to connect to another database, you need to specify dm_unicode="utf-16" in your caslib.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Data Connector to ODBCLinux for x64V.03.03V.03.05ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.