Problem Note 40110: When using Microsoft Access 2007 with the SAS ODBC Driver, you cannot insert DBCS characters into a SAS® character variable
 |  |  |  |  |
If you try to insert DBCS characters into a SAS character variable using the SAS ODBC Driver from Microsoft Access 2007, you will get an error, including an error message in your SAS/SHARE® server log, that looks similar to the following (this example is from a session that was encoded in Japanese):
23APR2010:15:09:59.880 When xxxxxx(2) in "ODBCAPPL"(0) tried to EXECUTE INSERT INTO TEMP.SAMPLE (x) VALUES ('D BY SQLVIEW:
ERROR: SQL パススルー式エラー : ERROR 79-322: ) を指定してください
The English translation of the last part of the message is "ERROR: SQL Pass-Through error : ERROR 79-322: specify ....".
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Drivers for ODBC | Microsoft® Windows® for x64 | 9.22 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.22 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.22 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.22 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 for x64 | 9.22 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.22 | 9.2 TS2M0 | ||||
| Microsoft Windows XP Professional | 9.22 | 9.2 TS2M0 | ||||
| Windows Vista | 9.22 | 9.2 TS2M0 | ||||
| Windows Vista for x64 | 9.22 | 9.2 TS2M0 | ||||
A fix for this issue for SAS Drivers for ODBC 9.22 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B43.html#40110A fix for this issue for SAS Drivers for ODBC 9.23 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B90.html#40110| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-06-29 11:31:40 |
| Date Created: | 2010-06-25 11:40:12 |