It turned out to solve the connection problem by using the "noprompt" parameter in assign library. These properties can be added to Other Options in SAS MC in the library properties. Example: LIBNAME <NAME> ODBC noprompt="uid=<login>;pwd=<password>;dsn=<name in odbc.ini>;server=<db host name>;database=<name of db>;" <other default assign options>;
... View more