SUPPORT / SAMPLES & SAS NOTES
Problem Note 32025: Problems occur because SAS/ACCESS® Interface to ODBC and SAS/ACCESS® Interface to OLE DB deliver unique identifiers differently
 |  |  |  |  |
SAS/ACCESS Interface to ODBC and SAS/ACCESS Interface to OLE DB use different formats to return globally unique identifiers (GUIDs) that are used in Microsoft SQL Server. SAS/ACCESS Interface to OLE DB encloses GUIDs in curly braces, whereas SAS/ACCESS Interface to ODBC does not. The following examples illustrate the two different formats:
- Using SAS/ACCESS Interface to ODBC: 6F9619FF-8B86-D011-B42D-00C04FC964FF
- Using SAS/ACCESS Interface to OLE DB: {6F9619FF-8B86-D011-B42D-00C04FC964FF}
When you try to insert data into the SQLServer table with the UniqueIdentifier column, the following error occurs:
ERROR: During insert: Data was not set for one or more columns. Data type
value could not be converted for column ColumnName
The difference in formatting can also be problematic when you join DBMS tables that contain the unique identifier with SAS data sets.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Windows Vista | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||