topic Re: SAS 9.4 /MuSQL: cannot load interface in SAS Programming

SAS 9.4 /MySQL: cannot load interface

ThibaultM — Fri, 23 Mar 2018 15:18:46 GMT

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

Re: SAS 9.4 /MuSQL: cannot load interface

ballardw — Fri, 23 Mar 2018 14:33:58 GMT

Run this code and examine the log to verify that the SAS/Access Interface to MySQL was actually installed.

proc product_status;run;

Sometimes SAS products available to your license aren't actually installed depending on a number of factors.

Also, is your install local or a server? A server version would likely not see a dll installed on your machine but could need a somewhat different approach.

Re: SAS 9.4 /MuSQL: cannot load interface

ThibaultM — Fri, 23 Mar 2018 15:23:06 GMT

I use local SAS

here is the code result :

 proc product_status;run;

For Base SAS Software ...
   Custom version information: 9.4_M3
   Image version information: 9.04.01M3P062415
For SAS/STAT ...
   Custom version information: 14.1
For SAS/GRAPH ...
   Custom version information: 9.4_M3
For SAS/ETS ...
   Custom version information: 14.1
For SAS/FSP ...
   Custom version information: 9.4_M3
For SAS/OR ...
   Custom version information: 14.1
For SAS/AF ...
   Custom version information: 9.4_M3
For SAS/IML ...
   Custom version information: 14.1
For SAS/QC ...
   Custom version information: 14.1
For SAS/ASSIST ...
   Custom version information: 9.4
   Image version information: 9.04.01M0P061913
For SAS/CONNECT ...
   Custom version information: 9.4_M3
For SAS/GIS ...
   Custom version information: 9.4_M3
For SAS/ACCESS Interface to Netezza ...
   Custom version information: 9.4_M3
For SAS/ACCESS to Hadoop ...
   Custom version information: 9.43
For SAS/ACCESS to Postgres ...
   Custom version information: 9.4_M3
For SAS/ACCESS to Impala ...
   Custom version information: 9.42
   Image version information: 9.04.01M0P062415
For SAS Integration Technologies ...
   Custom version information: 9.4_M3
For High Performance Suite ...
   Custom version information: 2.2_M4
For SAS/ACCESS Interface to DB2 ...
   Custom version information: 9.4_M2
For SAS/ACCESS Interface to Oracle ...
   Custom version information: 9.4_M3
For SAS/ACCESS Interface to Sybase ...
   Custom version information: 9.4_M2
For SAS/ACCESS Interface to PC Files ...
   Custom version information: 9.4_M3
For SAS/ACCESS Interface to ODBC ...
   Custom version information: 9.4_M3
For SAS/ACCESS Interface to OLE DB ...
   Custom version information: 9.4_M3
For SAS/ACCESS Interface to Teradata ...
   Custom version information: 9.43
For SAS/ACCESS Interface to MySQL ...
   Custom version information: 9.4_M3
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
      real time           0.10 seconds
      cpu time            0.04 seconds

Re: SAS 9.4 /MuSQL: cannot load interface

Vince_SAS — Mon, 26 Mar 2018 13:10:24 GMT

I suggest that you open a track with our Technical Support Department:

https://support.sas.com/ctx/supportform/createForm

They can help you to resolve this issue.

Vince DelGobbo

SAS R&D

Re: SAS 9.4 /MuSQL: cannot load interface

ThibaultM — Mon, 26 Mar 2018 13:47:16 GMT

Hello Vince,

I have juste solve it myself: I installed older version: MySQL Workbench 5.2.47 (the only 5.x version available for download).

My libmysql.dll working with SAS:

crc32 (windows 10): A9F1D85F
size: 4464640 bytes
version dll: 5.6.10.0

You should amend your documentation to install MySQL version 5.2.X, whether Workbench or Server version or ship the libmysql.dll along with SAS/access MySQL.

I hope that my post will avoid other people loosing time making it work SAS/access MySQL. (libmysql.dll is a lot faster than ODBC connector)

Thank you,

Thibault.