Error in Libname staement

[Survivindahel]

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?

[Kurt_Bremser]

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).