topic Re: Unable to connect to mySQL using SAS 9.4 in Administration and Deployment

Unable to connect to mySQL using SAS 9.4

anilreddam1 — Fri, 07 May 2021 14:22:10 GMT

I am getting the below error while trying to connect RDS (AWS) using SAS 9.4

ERROR: The MYSQL engine cannot be found.
ERROR: Error in the LIBNAME statement.

Re: Unable to connect to mySQL using SAS 9.4

snoopy369 — Fri, 07 May 2021 14:35:22 GMT

Do you have CONNECT to MYSQL ? Post these two things:

1. Your LIBNAME statement
2. Run this: PROC SETINIT; RUN; and paste anything that starts with SAS/ACCESS (or the whole thing).

Re: Unable to connect to mySQL using SAS 9.4

ballardw — Fri, 07 May 2021 14:35:24 GMT

Run this code:

proc setinit;run;

proc product_status; run;

The look in your log. The output for Setinit will tell you which products are licensed. If you do not see something like "SAS/Access Interface to mySQL" then you are not licensed to use it and need a change to the license and reinstall.

The Product_status tells which of the licensed products were actually installed. If you see the Interface to mySQL in the Setinit output but not Product_status that means it was not installed. If that is the case your or your Admin should be able to install it from the SAS Deployment Manager.

If you connect to a server to execute SAS then the SERVER would need the upgrades/reinstall.

Re: Unable to connect to mySQL using SAS 9.4

SASKiwi — Fri, 07 May 2021 22:58:42 GMT

If you aren't licensed for SAS/ACCESS to MySQL then SAS/ACCESS to ODBC is another possibility.