BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ThibaultM
Fluorite | Level 6

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:/

 

 

Screenshot from 2018-03-23 09-10-48.png

 

 

THank you for your help.

Thibault

 

 

edit : title MuSQL -> MySQL

1 ACCEPTED SOLUTION

Accepted Solutions
ThibaultM
Fluorite | Level 6

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.

View solution in original post

4 REPLIES 4
ballardw
Super User

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.

ThibaultM
Fluorite | Level 6

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
Vince_SAS
Rhodochrosite | Level 12

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

ThibaultM
Fluorite | Level 6

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 2526 views
  • 2 likes
  • 3 in conversation