Hello, I try to use mysql with libmysql.dll, but this does not work. Here are the facts: I have a fresh install of SAS 9.4 (TS1M3) with SAS/ACCESS mysql (valid licence) on a fresh install of windows 10. I have installed MySQL Workbench (6.3.10) and after that, because it was not working, I have installed MySQL server (5.7.21). I have added to system path both folders (MySQL workbench and server) containing libmysql.dl, but It still did not work. The script is working on an older computer. here is the script used : Libname tdm mysql user=genetiq password=bla server=crhsj104588 database=genetiq port = 3306 ; And here is the error : ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be
loaded.
ERROR: Error in the LIBNAME statement To verify the path : data _null_;
length result $10000;
input env_var $;
result=sysget(trim(env_var));
put env_var= result=;
datalines;
PATH ; Output : result=C:\Program Files\SASHome\x86\SASFoundation\9.4;C:\Program Files\Rtools\bin;C:\Program Files\R
tools\mingw_32\bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\Sys
tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\PuTTY\;C:\Program Files\SASH
ome\x86\SASFoundation\9.4\ets\sasexe;C:\Program Files\SASHome\Secure\ccme4;C:\Program Files\SASHome\
x86\Secure\ccme4;C:\Program Files\R\R-3.4.3\bin\x64;C:\Program Files\Java\jre1.8.0_161\bin;C:\Progra
m Files\MySQL\MySQL Server 5.7\lib;C:\Program Files\MySQL\MySQL Workbench 6.3 CE;C:\Users\demthi00\A
ppData\Local\Microsoft\WindowsApps; I joined a picture where I search for libmysql.dll in c:/ THank you for your help. Thibault edit : title MuSQL -> MySQL
... View more