AS/400
Standard
Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myPassword;
Variant
Try this if you encounter a "runtime error 3000; reserved error (-7778); there is no message for this error" message.
Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myPassword;MGDSN=0;