Date:         Wed, 6 Jan 2010 17:02:42 -0500
Reply-To:     "F. J. Kelley" <jkelley@UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "F. J. Kelley" <jkelley@UGA.EDU>
Subject:      Re: MySql and SAS problem (found somewhere )
In-Reply-To:  <c2192a611001061326v5f3e5d88o20093bbfcfe0efb5@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii

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@LISTSERV.UGA.EDU> (on behalf of SAS_learner <proccontents@GMAIL.COM>)
>Subject: [SAS-L] MySql and SAS problem (found somewhere )
>To: SAS-L@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;