SUPPORT / SAMPLES & SAS NOTES
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 | ||||