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.
Learn from the Experts! Check out the huge catalog of free sessions in the Ask the Expert webinar series.
SAS Innovate 2025: Save the Date
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.