it seems my SAS cannot access all folders in the path, i am running sas9.4 on windows10. in sas9.4, when i run below code: data _null_; format x $10000.; x=sysget('path'); put x=; run; it returns full path of various folders: x=C:\Program Files\SASHome\SASFoundation\9.4;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\MySQL\MySQL Connector C 6.1\lib; C:\xampp\mysql\bin;C:\xampp\mysql\lib; ......(and other folders' path) then, in sas, when i run libname mysqllib mysql user=xxxxx ..... return errors: ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be loaded. Actually, I already have libmysql.dll under my ...\MySQL\MySQL Connector C 6.1\ (i.e. the 3rd folder in the path) anyway, i try putting the libmysql.dll under the first folder in path (i.e. C:\Program Files\SASHome\SASFoundation\9.4;) and run again this "libname mysqllib mysql user=xxx" ..... , it works successfully! Then i deleted this dll under above \9.4 and now try putting this libmysql.dll in the 2nd folder in path (i.e. C:\ProgramData\Oracle\Java\javapath;), and run this "libname mysqllib mysql user=xxx", it fails again. So, i doubt SAS cannot successfully load in other folders in the path, except only able to load the 1st folder, am i right? any suggestion? thanks very much.
... View more