Prev: SAS92 32-BIT TO SAS92 64-BIT problem
Next: SAS Enterprise Guide - Documentation
From: "F. J. Kelley" on 6 Jan 2010 17:02
you don't say the version of SAS or MySQL you are using, but you might want to check
http://support.sas.com/kb/14/235.html

there are some other errors mentioned in a search at the SAS support site
http://support.sas.com/dsearch?rf=4&la=en&nh=100&qm=1&col=suppprd&qt=mysql+error

and you may want to contact SAS Tech Support.

---- Original message ----
>Date: Wed, 6 Jan 2010 13:26:49 -0800
>From: "SAS(r) Discussion" <SAS-L(a)LISTSERV.UGA.EDU> (on behalf of SAS_learner <proccontents(a)GMAIL.COM>)
>Subject: [SAS-L] MySql and SAS problem (found somewhere )
>To: SAS-L(a)LISTSERV.UGA.EDU
>
>Hello all,
>
>A friend of mine asked this question , ( I am database guy )
>
>
>1.i have connected to MySQL database.
>2.i am able to create,update,delete the table
>
>but..
>i am unable to use the select command
>
>ERROR: Read Access Violation In Task [ SQL )
>Exception occurred at (564B27DB)
>Task Traceback
>Address Frame (DBGHELP API Version 4.0 rev 5)
>564B27DB 0491DA2C sasmyl:mcn_main+0x17DB
>777BFD07 0491FFD4 ntdll:RtlInitializeExceptionChain+0x63
>777BFCDA 0491FFEC ntdll:RtlInitializeExceptionChain+0x36
>
>NOTE: The SAS System stopped processing this step because of errors.
>NOTE: PROCEDURE SQL used (Total process time):
>real time 0.56 seconds
>cpu time 0.18 seconds
>
>
>my code is
>PROC SQL;
>CONNECT TO MYSQL(USER=root PASSWORD=fastfast DATABASE=jaswanth PORT=3306);
>
>select * from connection to mysql
>(select * from jk);
>DISCONNECT FROM MYSQL;
>quit;
 | 
Pages: 1
Prev: SAS92 32-BIT TO SAS92 64-BIT problem
Next: SAS Enterprise Guide - Documentation