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
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 | |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2010-06-29 11:31:40 |
Date Created: | 2010-06-25 11:40:12 |