Usage Note 35092: Unable to perform union of two queries in Microsoft Access when connecting to SAS® Scalable Performance Data Server via ODBC
 |  |  |  |  |
Prior to SAS Scalable Performance Data Server 4.4TSM8, you will receive errors when performing a UNION between Microsoft Access and a SAS Scalable Performance Data Server table.
For example, issuing the following statement:
SELECT * FROM X0000001_PRDSALE union SELECT * FROM X0000001_PRDSALE;
May generate the following error:
"ODBC -- call failed. SAS][SAS ODBC Driver][SAS Server]SPDS_ERROR (#-1)"
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Windows Vista | 4.4 TSM0 | 4.4 TSM8 | ||
| Microsoft Windows XP Professional | 4.4 TSM0 | 4.4 TSM8 | ||||
| Microsoft Windows 2000 Professional | 4.4 TSM0 | 4.4 TSM8 | ||||
A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#035092| Type: | Usage Note |
| Priority: |
| Date Modified: | 2009-08-25 15:16:04 |
| Date Created: | 2009-03-10 15:34:43 |