Hello,
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)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
10025ACF 039AF7E0 myodbc5a:SQLSetConnectAttr+0x24408
1003005C 039AF7FC myodbc5a:SQLSetConnectAttr+0x2E995
10029B09 039AF830 myodbc5a:SQLSetConnectAttr+0x28442
10028449 039AF84C myodbc5a:SQLSetConnectAttr+0x26D82
100199C8 FFFFFFFF myodbc5a:SQLSetConnectAttr+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.
Thanks