SUPPORT / SAMPLES & SAS NOTES
Problem Note 56606: When you are using the MySQL ODBC 5.3 Unicode driver, SAS® might return a Read Access Violation error
 |  |  |  |  |
You might receive a Read Access Violation error when connecting to MySQL using SAS/ACCESS® Interface to ODBC. This issue occurs if you are using the MySQL ODBC 5.3 Unicode driver and you specify Driver= in your LIBNAME statement. The resulting error looks similar to the following:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [SQL]
ERROR: Read Access Violation SQL
Exception occurred at (2229C567)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
000000002229C567 00000000229DED10 sasioodb:tkvercn1+0x1B527
000000002229BE8C 00000000229DF390 sasioodb:tkvercn1+0x1AE4C
0000000022339C80 00000000229DF398 sasxdbi:tkvercn1+0x38C40
0000000022324548 00000000229DF550 sasxdbi:tkvercn1+0x23508
00000000232619DC 00000000229DF558 sassqp:tkvercn1+0x99C
00000000232613E3 00000000229DF920 sassqp:tkvercn1+0x3A3
00000000221B2510 00000000229DF928 sassqx:tkvercn1+0x314D0
00000000221B1E80 00000000229DFB60 sassqx:tkvercn1+0x30E40
0000000022161330 00000000229DFB68 sassql:tkvercn1+0x2F0
00000000034B8A2B 00000000229DFBF8 sashost:Main+0x10F0B
00000000034BE65D 00000000229DFF50 sashost:Main+0x16B3D
00000000776759ED 00000000229DFF58 kernel32:BaseThreadInitThunk+0xD
00000000778AC541 00000000229DFF88 ntdll:RtlUserThreadStart+0x21
SAS WTABORT (SQL) The SAS System has detected an abort condition. An Exception occurred during
wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[0337C3A0] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[0337C3A0]
[EVENTTSK] [WAITING ] pri[ 0] reb[0337C3A0] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[0337C3A0] WC[0] WN[1]
[SGIOREAD] [WAITING ] pri[ 3] reb[0337C3A0] WC[0] WN[1]
[SGIOWRIT] [WAITING ] pri[ 3] reb[0337C3A0] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[04B8CE00] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[04B8D3B0] WC[0] WN[1]
[DMS Proc] [WAITING ] pri[ 7] reb[04B8DCC0] WC[0] WN[1]
[Language] [WAITING ] pri[ 7] reb[04B8DCC0] WC[0] WN[1]
[RESULTS ] [WAITING ] pri[ 7] reb[04DAFBC0] WC[0] WN[1]
[XUIDLE ] [READY ] pri[ 8] reb[04B94900]
[SASODR ] [WAITING ] pri[ 3] reb[05FFA2E0] WC[0] WN[1]
[SASVODSV] [READY ] pri[ 7] reb[05FFA5A0]
[DMSEXP ] [WAITING ] pri[ 7] reb[0600C970] WC[0] WN[1]
[lst ] [WAITING ] pri[ 7] reb[068C4F60] WC[0] WN[1]
[log ] [WAITING ] pri[ 7] reb[068C5220] WC[0] WN[1]
[pgm ] [WAITING ] pri[ 7] reb[07A33920] WC[0] WN[1]
[Enhanced] [WAITING ] pri[ 7] reb[07A33BE0] WC[0] WN[1]
[Submit ] [WAITING ] pri[ 3] reb[04B8DCC0] WC[0] WN[1]
[SQL ] [RUNNING ] pri[ 3] reb[21936C40]
Traceback
SASTBTraceBackCtx has been called with a
string ("vacrash") instead of a CONTEXT pointer.
Address Frame (DBGHELP API Version 4.0 rev 5)
000007FEFD94940D 00000000229DC8E0 KERNELBASE:RaiseException+0x3D
00000000020CECEB 00000000229DC8E8 tkmk:tkBoot+0x4CFAB
00000000020CEAB9 00000000229DCE30 tkmk:tkBoot+0x4CD79
00000000020C53CA 00000000229DCE80 tkmk:tkBoot+0x4368A
00000000034B00A9 00000000229DCE88 sashost:Main+0x8589
00000000034A1FC6 00000000229DCF30 sashost:rtmdoit+0x246
00000000034B4B5B 00000000229DD0A0 sashost:Main+0xD03B
00000000034B8438 00000000229DD230 sashost:Main+0x10918
00000000034BE4A8 00000000229DD800 sashost:Main+0x16988
00000000034BDD1B 00000000229DDB10 sashost:Main+0x161FB
00000000034BE680 00000000229DDB40 sashost:Main+0x16B60
000000000360348F 00000000229DDBB0 sashost:Main+0x15B96F
00000000778A9D2D 00000000229DDBB8 ntdll:RtlDecodePointer+0xAD
00000000778991CF 00000000229DE2C0 ntdll:RtlUnwindEx+0xBBF
00000000778D1248 00000000229DE880 ntdll:KiUserExceptionDispatcher+0x2E
000000002229C567 00000000229DE888 sasioodb:tkvercn1+0x1B527
000000002229BE8C 00000000229DF390 sasioodb:tkvercn1+0x1AE4C
0000000022339C80 00000000229DF398 sasxdbi:tkvercn1+0x38C40
0000000022324548 00000000229DF550 sasxdbi:tkvercn1+0x23508
00000000232619DC 00000000229DF558 sassqp:tkvercn1+0x99C
00000000232613E3 00000000229DF920 sassqp:tkvercn1+0x3A3
00000000221B2510 00000000229DF928 sassqx:tkvercn1+0x314D0
00000000221B1E80 00000000229DFB60 sassqx:tkvercn1+0x30E40
0000000022161330 00000000229DFB68 sassql:tkvercn1+0x2F0
00000000034B8A2B 00000000229DFF20 sashost:Main+0x10F0B
00000000034BE65D 00000000229DFF50 sashost:Main+0x16B3D
00000000776759ED 00000000229DFF58 kernel32:BaseThreadInitThunk+0xD
00000000778AC541 00000000229DFFD0 ntdll:RtlUserThreadStart+0x21
- Use the MySQL ANSI ODBC driver.
- Create an ODBC data source. You would then have dsn=xxxx in your code, instead of "Driver={MySQL ODBC 5.3 Unicode Driver};"
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 MySQL | Microsoft® Windows® for x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 9.4 TS1M2 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 9.4 TS1M2 | 9.4 TS1M3 | ||
| HP-UX IPF | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Solaris for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||