The following error might be issued when you access MySQL using SAS/ACCESS Interface to MySQL:

This error might be issued because the MySQL client is not listed in the system path or the UNIX environment variables are not set appropriately.

You need to make sure that the location of the libmysql.dll file is in your Windows system PATH. Under UNIX, make sure that the LIBPATH, SHLIB_PATH, or LD_LIBRARY_PATH environment variables are set to the MySQL client libraries, and that they are set correctly.

If you have verified that the libmysql.dll file is in your system path and you still get the above error, search your machine for all instances of the libmysql.dll file to make sure that another copy does not exist in a directory on the path.

Full support of MySQL 5.0 is available in SAS^® 9.2. If you are using SAS^® 9.1.3, you need to install the hot fix in SAS Note 18824 after you have the MySQL client library installed on your SAS system and it is set in your SYSTEM PATH setting as previously mentioned.

At this time, the only known problem in MySQL 5.0 is with the decimal fields, which are read as character fields.

Operating System and Release Information