Hi All,
My team member is trying to run below libname but it failing for him with below error .
He and I have been added to same user group and has permission . When it is running from SAS EG it is failing , what thing I have to check ?
28 libname oracle2 odbc dsn=AXXBS user=IXX password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX schema=XX_A50709;
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver
specified
ERROR: Error in the LIBNAME statement.
My system
28 libname oracle2 odbc dsn=AXXBS user=IXXX
29 password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX schema=XX_A50709;
NOTE: Libref ORACLE2 was successfully assigned as follows:
Engine: ODBC
Physical Name: ALDBS
The error message tells us that SAS cannot find the DSN 'AXXBS' that you've specified in your libname statement.
If the user is running SAS locally, they can check there ODBC data source administrator and make sure they have AXXBS set up correctly.
If its not there they'll need the connection information to the data source of AXXBS and they'll need to set up a working DSN.
Given you are running this in EG, it appears the DSN AXXBS is not defined on the SAS Application server. If this is running on Windows then the DSN can be added to the Windows ODBC Administrator, if Unix to odbc.ini.
Hello @MG18
The error means the connection to database is not configured in the first case.
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.