The data management people in my company (who are not SAS users) have sent me information to connect to one of our Redshift servers:

User ID: user

Password: pwd

Database Server: svr123

Database Port: 1234

Database: db123

Schema: data_schema_123

My SAS libname statement is as follows:

libname newlib redshift 
user="user" 
password="pwd" 
READBUFF=10000 SUB_CHAR=QUESTIONMARK 
schema="data_schema_123"
database="db123"
server="svr123"
port=1234;

I’m seeing the following error message after executing:

ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.

Is there anything obviously wrong with my syntax or is this more of an IT issue?