Issue Importing MYSQL tables to SAS

[CaseK]

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

[SASKiwi]

Have you tried searching SAS support? I found this which might help:

http://support.sas.com/kb/16/329.html

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.

[CaseK]

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,