topic Re: Libname Error in Administration and Deployment

Libname Error

ksuman — Wed, 27 Nov 2013 15:48:42 GMT

Hi,

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.

Thanks,

Reddy

Re: Libname Error

Amir — Thu, 28 Nov 2013 12:51:22 GMT

Hi,

Does the following SAS Note apply?:

37512 - An OPTIONS statement is not required when you connect to the MySQL database with SAS/ACCESS® Interface to MySQL

Regards,

Amir.

Re: Libname Error

ksuman — Thu, 28 Nov 2013 18:18:26 GMT

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" ;