BookmarkSubscribeRSS Feed
ksuman
Obsidian | Level 7

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

2 REPLIES 2
ksuman
Obsidian | Level 7

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1358 views
  • 1 like
  • 2 in conversation