Variant using iSeries Access ODBC
Connection string
This IBM iSeries Access ODBC driver connection string can be used for connections to AS/400.
Try this if you encounter a "runtime error 3000; reserved error (-7778); there is no message for this error" message.
Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;
Pwd=myPassword;MGDSN=0;