Usage Note 50165: The error "The SASMYL code appendage could not be loaded" occurs when you use SAS® software in a UNIX environment and connect to a MySQL database
When connecting to a MySQL database using the SAS/ACCESS
® Interface to MySQL and SAS on a UNIX operating system, you might receive this error message:
ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The SASMYL code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
This error occurs because SAS/ACCESS Interface to MySQL requires additional configuration. To do this additional configuration, follow the steps to run the SAS
® Deployment Manager or run a series of UNIX commands to create the SASMYL file manually.
Starting the SAS Deployment Manager
- Start the SAS Deployment Manager located in <SASHOME>/SASDeploymentManager/9.x by issuing the command ./sasdm.sh.
- Choose your language.
- Choose Configure SAS/ACCESS Interface to MySQL and click Next.
- Choose the version of the MySQL client from the drop-down menu and click Next.
- Click Next and then click Start.
- When you see a successful configuration of SAS/ACCESS Interface to MySQL, click Finish.
Creating the SASMYL File Manually
- Navigate to <SASHOME>/SASFoundation/9.x/sasexe
.
- Use this command to search for a file starting with "my":
ls -la my*
- Create the file sasmyl by linking to the "my*" file you found above:
ln -s myXXX### sasmyl
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to MySQL | 64-bit Enabled AIX | | |
| 64-bit Enabled HP-UX | | |
| 64-bit Enabled Solaris | | |
| HP-UX IPF | | |
| Linux | | |
| Linux for x64 | | |
| Linux on Itanium | | |
| Solaris for x64 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2013-07-01 11:05:02 |
| Date Created: | 2013-06-11 11:10:25 |
