08-26-2013 05:56 PM
I am trying to read in some fairly large MYSQL datasets (~40GB) with SAS/ACCESS through ODBC. I get the following error:
ERROR: Write Access Violation In Task [ DATASTEP (2) )
Exception occurred at (10025ACF)
Address Frame (DBGHELP API Version 4.0 rev 5)
10025ACF 039AF7E0 myodbc5aQLSetConnectAttr+0x24408
1003005C 039AF7FC myodbc5aQLSetConnectAttr+0x2E995
10029B09 039AF830 myodbc5aQLSetConnectAttr+0x28442
10028449 039AF84C myodbc5aQLSetConnectAttr+0x26D82
100199C8 FFFFFFFF myodbc5aQLSetConnectAttr+0x18301
I have read on the SAS site that this may be caused by not having enough memory to allocate, but I'm not sure. Does anyone know a better way to get the data in?
I am running SAS 9.1.3 EG 4.1. The problem seems to be specific to the MYSQL datasets, as I've been able to work with larger datasets that are in SQL Server 2008.
08-26-2013 07:35 PM
Have you tried searching SAS support? I found this which might help:
Do smaller tables work OK? Are you using EG local server or remote server? What is your SAS memsize setting?
Also worth raising a track with SAS Support for more help.
08-28-2013 06:42 PM
Thanks, I have searched SAS support, but none of the Problem Notes seemed to help.
I'm using EG remote server, with memsize = 0. Smaller tables import fine from the same MySQL server.
I have a request in to change the ODBC settings, hopefully that works.
Thanks for your help,