Problems loading MySQL, SAS/ACCESS (please help!!!)

shiyiming

My code is:

            libname abc mysql user=root password=345  server=localhost database=firstmonth    port=3306;

The log is:  
ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be  loaded.
ERROR: Error in the LIBNAME statement.

I am sure that my information ( user ,passward,server,database,etc) are all right. My sas version is 9.1.3.

Will you help to tell what's the reason?



Thanks so much!

shiyiming

你的mysql是什么版本的？
试试看在你的程序前加options set=SASMYL MYWIN417;或者在CFG文件中加-set SASMYL MYWIN417。
<!-- m --><a class="postlink" href="http://support.sas.com/techsup/unotes/SN/014/014235.html">http://support.sas.com/techsup/unotes/S ... 14235.html</a><!-- m -->

shiyiming

Thanks  shiyiming !
     My sql server is 5.0 and I  tried both
1: Add
options set=SASMYL MYWIN417;
    infront of my program.
2: Add  -set SASMYL MYWIN417
    inmy CFG file.

but I got the same  error messages  in the log file.

Another question,
I have 4 CFG files in diffrent folder, should I put
-set SASMYL MYWIN417 in all of the CFG files or either one is okay!

Thanks again!