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
 |  |  |  |  |
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to ODBC | Linux for x64 | V.03.03 | V.03.05 | Viya | Viya |
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesViya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-03-14 12:14:47 |
| Date Created: | 2019-01-15 10:43:30 |