https://communities.sas.com/t5/SAS-Procedures/Accessing-tables-in-mySQL/m-p/38460#M9861 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:<BR /> <BR /> libname fred mysql <LOGIN info="">;<BR /> proc print data = fred.test;<BR /> run;<BR /> <BR /> 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.</LOGIN> Fri, 08 Jan 2010 21:51:26 GMT jlcalbre 2010-01-08T21:51:26Z https://communities.sas.com/t5/SAS-Procedures/Accessing-tables-in-mySQL/m-p/38460#M9861 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:<BR /> <BR /> libname fred mysql <LOGIN info="">;<BR /> proc print data = fred.test;<BR /> run;<BR /> <BR /> 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.</LOGIN> Fri, 08 Jan 2010 21:51:26 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-tables-in-mySQL/m-p/38460#M9861 jlcalbre 2010-01-08T21:51:26Z https://communities.sas.com/t5/SAS-Procedures/Accessing-tables-in-mySQL/m-p/38461#M9862 Recommended Google advanced search argument to consider (several potential matches show up as I noticed):<BR /> <BR /> ERROR: Read Access Violation In Task site:sas.com<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 08 Jan 2010 22:16:37 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-tables-in-mySQL/m-p/38461#M9862 sbb 2010-01-08T22:16:37Z