- ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be
- loaded.
- ERROR: Error in the LIBNAME statement.
1.下载安装MySQL. http://www.mysql.com/
2.修改环境变量path.增加路径C:\Program Files\MySQL\MySQL Server 5.6\lib,路径下面应该包含 libmysql.dll
3.重启电脑,测试
- 1 libname mysqllib mysql user='mysql' password=XXXXX database=sas
- 2 server='192.168.1.150' port=3306;
- NOTE: Libref MYSQLLIB was successfully assigned as follows:
- Engine: MYSQL
- Physical Name: 192.168.1.150
- 3 proc sql;
- 4 connect to mysql as dbcon
- 5 (user=mysql password=XXXXX server='192.168.1.150'
- 6 database=sas port=3306);
- 7 quit;
- NOTE: PROCEDURE SQL used (Total process time):
- real time 0.26 seconds
- cpu time 0.01 seconds
linux sas连接MySQL应该也需要设置环境变量。尚在测试中。。