Help using Base SAS procedures

Accessing tables in mySQL

Reply
Occasional Contributor
Posts: 9

Accessing tables in mySQL

I used libname to establishe a connection to a mySQL database. I can see all of the tables in the explorer window, but when Itry to accss any of them, such as through proc print, I get a message that says: ERROR: Read Access Violation In Task [ PRINT ). My code looks like:

libname fred mysql ;
proc print data = fred.test;
run;

My understanding was that once the connection is established with the libname, which seems to work fine, I can use the usual 2 level name convention (libname.dataset) and access the table like any other SAS dataset. But that doesn't seem to be working. Any ideas on what the problem is? Thanks.
Super Contributor
Super Contributor
Posts: 3,174

Re: Accessing tables in mySQL

Recommended Google advanced search argument to consider (several potential matches show up as I noticed):

ERROR: Read Access Violation In Task site:sas.com

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 171 views
  • 0 likes
  • 2 in conversation