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;
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.
# Driver: The location where the ODBC driver is installed to.
Description=Amazon Redshift ODBC Driver (64-bit) DSN
# Required: These values can also be specified in the connection string.
Could you please let me know the solution to resolve at the earliest.
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.
@SimonDawson makes a very good point.
If you have not already done so, have a look at the Redshift configuration in this guide:
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.