Error in Libname staement

Survivindahel — Sun, 15 Oct 2017 05:40:02 GMT

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?

Re: Error in Libname staement

Kurt_Bremser — Sun, 15 Oct 2017 05:57:59 GMT

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

topic Error in Libname staement in Administration and Deployment

Error in Libname staement

Re: Error in Libname staement