11-27-2013 10:48 AM
I have set the mysql lib path in /SASFoundation/9.3/bin/ sasenv_local file and set the env path's of mysql and restarted the services twice, But still i'm facing this libname error when i ran in DI Studio
ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The SASMYL code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
Can any one please help me.
11-28-2013 01:18 PM
Thanks for the replay Amir.
But I'm not using Options statement
LIBNAME PROPHET MYSQL ACCESS=READONLY SPOOL=NO CONNECTION=SHAREDREAD DIRECT_EXE=DELETE SQL_FUNCTIONS=ALL MYSQL_PORT=3306 SERVER="server_name" DATABASE=db_name USER=db_password PASSWORD="password" ;