topic Problem when trying to access MySQL database. in SAS Procedures

Problem when trying to access MySQL database.

deleted_user — Tue, 06 Jan 2009 10:48:16 GMT

Hello, I am trying to connect to MySQL database using SAS Base via libname statement. The connection establishes fine and i can see the library and the tables in the explorer.

The problem starts when I try to open the tables or read any kind of information about them (like column list or other properties).

Here is some output from the log:
ERROR:Generic Critical Error
Read Access Violation In Task (View Table Window)
Exception Occured at (564B27DB)
After that there goes the task traceback and the last line of it is:
kernel32:GetModuleFileNameA+0xlB4.

I can paste the whole traceback if requested, but i guess it's not that important since that part differs for different procedures.

Re: Problem when trying to access MySQL database.

Cynthia_sas — Tue, 06 Jan 2009 11:45:32 GMT

Hi:
This Tech Support track may be relevant to your issue:
http://support.sas.com/kb/19/511.html

If not, I recommend that you open a track with Tech Support. They are the best resource to help with Generic Critical Errors.

cynthia

Re: Problem when trying to access MySQL database.

deleted_user — Thu, 08 Jan 2009 05:56:14 GMT

Yes, the above posted track looks really similar to what I am experiencing, but the given solutions didn't solve the problem. Are there any other ideas on why would that be happening?
http://support.sas.com/kb/31/060.html
This one definately describes my problem, but I'm using MySQL 4.1.