Problem Note 57359: SAS/ACCESS® Interface to ODBC and SAS/ACCESS® Interface to Oracle crash if you are using the Oracle version 12 client with LDAP service
 |  |  |  |
If you are using the 32-bit Oracle version 12 ODBC driver or the Oracle client, issuing one the following LIBNAME statements might cause an error:
libname odbclib odbc dsn=ora12c uid=user-ID pwd=password;
libname oralib oracle path=ora12c uid=user-ID pwd=password;
The error might look like the following:
The SAS System has detected an abort condition. An Exception occurred during wthtrm(). Please Contact Technical Support.
To work around the issue, do one of the following:
- Use the 64-bit version of SAS® rather than the 32-bit version.
- Use the Microsoft ODBC driver for Oracle (MSORCL32).
- Use the TNSNAMES service instead of LDAP.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Windows 7 Ultimate 32 bit | 9.4_M3 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows 8 Pro 32-bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Windows 7 Enterprise 32 bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Windows 7 Home Premium 32 bit | 9.4_M3 | 9.4 TS1M3 | ||||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows 8 Enterprise 32-bit | 9.4_M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows 8 Pro 32-bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M3 | 9.4 TS1M3 | ||||
| Type: | Problem Note |
| Priority: | high |
| Topic: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity) |
| Date Modified: | 2016-02-15 10:21:56 |
| Date Created: | 2016-01-06 10:34:16 |