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?
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;
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
Looks like this SAS Note is relevant: http://support.sas.com/kb/19/250.html
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.
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.