Problem Note 14235: Using SAS/ACCESS® Interface to MySQL with the MySQL 4.1 client generates an error
In SAS® 9.1.3, SAS/ACCESS Interface to MySQL only works with releases
4.0.14 or 4.1.7 and higher of the MySQL client. The LIBNAME statement
is assigned successfully, but you receive the following error message
when you open a table or a view:
libname my mysql database=test port=3306 server=localhost user=root
password=password;
ERROR: Read Access Violation In Task [ DATASTEP )
Exception occurred at (564B1EE8)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
564B1EE8 04EBF564 sasmyl:mcn_main+0xEE8
564C7BCE 04EBF5DC sasiomyl:mcn_main+0x6BCE
ERROR: Generic critical error.
Using the SQL Pass-Through procedure generates a similar error message.
For release 4.1.7 or higher of the MySQL client, you need to set the
SASMYL option so that SAS/ACCESS Interface to MySQL can identify your
version of the MySQL client. You can You can set the SASMYL option
either at the beginning of your SAS program or in ther SASV9.CFG file.
To set the SASMYL option in your SAS program, add the following OPTIONS
statement at the beginning of your SAS program:
options set=SASMYL MYWIN417;
The SASV9.CFG file is located in the !SASROOT directory. To set the
SASMYL option in this file, add the following line:
-set SASMYL MYWIN417
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to MySQL | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
*
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.
| Type: | Problem Note |
| Priority: | alert |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> MySQL
|
| Date Modified: | 2006-09-20 14:54:28 |
| Date Created: | 2005-01-18 20:55:32 |