IBM iSeries Access ODBC driver connection strings

AS/400

Standard

This driver is newer than the one above.

Driver={iSeries Access ODBC Driver};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={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;Pwd=myPassword;MGDSN=0;