Error while connecting to Redshift using Libname statement

[karthic2612]

Hi Team,

Receiving error while running the libname statement to connect redshift through odbc engine.

libname redshift ODBC datasrc=MyRedshift user=cyrus_disc_adm password=CyrusAdm!n123;

Error

libname redshift ODBC datasrc=MyRedshift user=cyrus_disc_adm password=XXXXXXXXXXXXX;
ERROR: CLI error trying to establish connection: 523 586
ERROR: Error in the LIBNAME statement.

I have installed and configured the Redshift odbc drivers in SAS server. 

[MyRedshift]
# Driver: The location where the ODBC driver is installed to.
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
Description=Amazon Redshift ODBC Driver (64-bit) DSN
# Required: These values can also be specified in the connection string.
Host=cyrus-discovery-cluster-dev-rs01.cktinyynazra.us-east-1.redshift.amazonaws.com
Port=5439
Database=cyrusdiscoverydb
locale=en-US

Could you please let me know the solution to resolve at the earliest.

Thanks,

Vishal

[nhvdwalt]

Hi @karthic2612

For security reasons it strongly discouraged to publish user names, passwords or server names online. This is a public forum so it is accessible by everyone on the internet.

I would advise you to immediately change your AWS password if the values in your post are real values.

[karthic2612]

Sure. Thanks for your advice.

Could you please help me in resolving this issue

Thanks,

Vishal

[nhvdwalt]

Hi @karthic2612

Using a simple telnet command, could you try and ping that hostname + port. We need to establish if there is a network path to that host + port. You'll need to do this from the SAS server where your code is running.

[Swagat711]

On thr configuration tab, under Cluster properties , Copy the URL of cluster for databse details and paste it in odbc.ini

After that check the connection by isql command

isql -v Myredshift username password

[SimonDawson · Accepted solution]

ERROR: CLI error trying to establish connection: 523 586

Your error messages are not resolved to error messages. This typically mean your environment variables are misconfigured. If they are correctly setup the numbers will be actual strings describing whats wrong.

[nhvdwalt]

@SimonDawson makes a very good point.

If you have not already done so, have a look at the Redshift configuration in this guide:

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

[BillPerkins]

A clue as to what environment variable is misconfigured would be helpful here.