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-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 1122 views
  • 4 likes
  • 3 in conversation