connecting to MYSQL from SAS Miner

[Sivateja]

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?

[SASKiwi]

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]

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

[SASKiwi]

Looks like this SAS Note is relevant: http://support.sas.com/kb/19/250.html

[SimonDawson]

@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.