BookmarkSubscribeRSS Feed
Sivateja
Fluorite | Level 6

Hi Guyz,

 

I was just wondering if I can connect to MYSQL database from SAS Miner Workstation 14.1 and update tables in the database?

 

Can you take me through the steps?

 

4 REPLIES 4
SASKiwi
PROC Star

To connect to MySQL you will need either SAS/ACCESS to MySQL or the more general SAS/ACCESS to ODBC products. These aren't necessarily bundled with SAS Enterprise Miner. You can confirm what products you have licensed by running this code: proc setinit noalias; run;

Sivateja
Fluorite | Level 6

HI, I do have SAS/ACCESS I checked its status by proc product_status; still I'm not able to connect to MySQL it is throwing me an error in the log saying 

 

ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be
loaded.
ERROR: Error in the LIBNAME statement.

 

The code I'm using is:

libname mysqlib mysql user=XYZ password=XXXXXXXXXX database=database name

 server=mysqlserv port = 3306;

proc print data = Siva.Table;
run;

 

Please let me know if I'm missing something

SimonDawson
SAS Employee

@Sivateja please consult the Configuration Guide for SAS® 9.4 Foundation for Microsoft Windows for x64 manual here. There is a section titled "SAS/ACCESS Interface to MYSQL" please review that section and follow the steps.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1422 views
  • 4 likes
  • 3 in conversation