Usage Note 37512: An OPTIONS statement is not required when you connect to the MySQL database with SAS/ACCESS® Interface to MySQL
 |  |  |  |
When you submit a LIBNAME statement with a libref pointing to MySQL with SAS/ACCESS Interface to MySQL, the following OPTIONS statement is not required for SAS® 9.2 or later.
options set=sasmyl mywin417;
When you use this OPTIONS statement in SAS 9.2 or later, you 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.
Remove the OPTIONS statement from your code to connect successfully to MySQL.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to MySQL | Microsoft® Windows® for x64 | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |||
| Microsoft Windows XP Professional | 9.2 TS1M0 | |||
| Windows Vista | 9.2 TS1M0 | |||
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MySQL |
| Date Modified: | 2009-10-21 15:50:57 |
| Date Created: | 2009-10-20 15:51:41 |