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.
Is the DSN a machine/system DSN or a User DSN? That might make a difference.
Also, if using Kerberos or IWA, there might be a Trusted for Delegation change needed. With the RSUBMIT, you're introducing an addition network hop between the client(s) and the target database.
Moving this topic to Data Management for more experts to see it.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.