SQLCMD: ERROR: Microsoft ODBC Driver 17 for SQL Server: Data source name not found
The problem is that if I run the command through the Putty, everything works fine, the table updates and no errors. But as soon as I run this code in SAS as:
X “sqlcmd ….”; the output says, that “SQLCMD: ERROR: Microsoft ODBC Driver 17 for SQL Server: Data source name not found”.