Table names are displayed using garbage characters when you use SAS/ACCESS Interface to Microsoft SQL Server under Unix versus when you use SAS/ACCESS^® Interface to ODBC in the Windows environment.

For example, the following LIBNAME statement(with SQLSVR or ODBC and engine) and DATASETS procedure display the table name correctly under Windows. However, under UNIX, the table names appear as garbage characters.

   libname test SQLSVR/ODBC user=userid pw=password dsn=datasource_name
           schema=dbo preserve_col_names=yes preserve_tab_names=yes;

   proc datasets lib=test;

Under UNIX, the DataDirect ODBC option IANAAppCodePage=38 needs to be added to the ODBC.INI under the datasource they are using.

Here's an example of how to update the DataDirect options in the ODBC.INI file.

   [datasource_name]
   Driver=/sas/sasv9/mssql/lib/S0msss21.so
   Description=DataDirect 5.1 SQL Server Wire Protocol
   Address=10.10.77.232,1433
   AnsiNPW=Yes
   Database=GWSaisHMC
   LogonID=userid
   Password=password 
   QuotedId=No
   IANAAppCodePage=38

The IANAAppCodePage value tells the driver which code page SAS or another application is running in. The 38 corresponds to EUC_KR.

Operating System and Release Information