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.
SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.