SAS中文论坛

标题: Problems loading MySQL, SAS/ACCESS (please help!!!) [打印本页]

作者: shiyiming 时间: 2007-4-9 14:28
标题: Problems loading MySQL, SAS/ACCESS (please help!!!)
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 时间: 2007-4-9 19:17
标题: to honeyamy
你的mysql是什么版本的？
试试看在你的程序前加options set=SASMYL MYWIN417;或者在CFG文件中加-set SASMYL MYWIN417。
<a class="postlink" href="http://support.sas.com/techsup/unotes/SN/014/014235.html">http://support.sas.com/techsup/unotes/S ... 14235.html</a>

作者: shiyiming 时间: 2007-4-10 01:31
标题: to 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!

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)