BookmarkSubscribeRSS Feed
anilreddam1
Calcite | Level 5

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.

3 REPLIES 3
snoopy369
Barite | Level 11
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).
ballardw
Super User

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.

SASKiwi
PROC Star

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 934 views
  • 2 likes
  • 4 in conversation