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