topic CLI Error in Libname in Administration and Deployment

CLI Error in Libname

MG18 — Tue, 16 Aug 2022 14:49:37 GMT

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

Re: CLI Error in Libname

anuraagjv — Tue, 16 Aug 2022 15:13:20 GMT

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.

Re: CLI Error in Libname

SASKiwi — Tue, 16 Aug 2022 20:16:46 GMT

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.

Re: CLI Error in Libname

Sajid01 — Tue, 16 Aug 2022 22:38:55 GMT

Hello @MG18
The error means the connection to database is not configured in the first case.