BookmarkSubscribeRSS Feed
Survivindahel
Calcite | Level 5

Hi All,

 

Was trying to connect to the Redshift database and have installed the necessary drivers that needs to be in place.

Also provided all the connection details in the odbc.ini file.

 

When I try executing the libname statement in SAS EG I  get the following error.

 

LIBNAME bluem ODBC DSN='sasredshift' user=it_market_user password=XXXXXX schema=pub_glbl;

 

ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Can't open lib
'/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so' : file not found
ERROR: Error in the LIBNAME statement.

 

But the same libname statement runs fine when run from the command line (Linux OS ). I am also able to list the contents of one of the tables in the schema.

 

NOTE: Libref BLUEM was successfully assigned as follows:
Engine: ODBC
Physical Name: sasredshift

 

 

What could I be missng here?

1 REPLY 1
Kurt_Bremser
Super User

Run

set

from the commandline and look for redshift-specific environment variables and values, especially in PATH and LIBPATH.

Then set these in the WorkspaceServer_usermods.sh file of your workspace server (most probably SASApp).

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
  • 1 reply
  • 921 views
  • 0 likes
  • 2 in conversation