• IBM DB2 for i .NET data provider

    • Standard

      DataSource=myServerAddress;UserID=myUsername;Password=myPassword;
      DataCompression
      =True;
      AS/400

    Problems connecting?   Get answer in the AS/400 Q & A forum →

  • IBM Client Access OLE DB provider

    • Standard

      Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;
      Password
      =myPassword;

      Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigator

      AS/400
    • Specifying cellection

      Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;
      Password
      =myPassword;Default Collection=MY_LIBRARY;

      Where MY_SYSTEM_NAME is the name given to the System Connection, and MY_LIBRARY is the name given to the library in iSeries Navigator.

      AS/400
  • .NET Framework Data Provider for OLE DB

    • Use an OLE DB provider from .NET

      Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

      See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

  • IBM Client Access ODBC driver

    • Standard

      Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;
      Pwd
      =myPassword;
      AS/400
    • 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;
      AS/400
  • IBM iSeries Access ODBC driver

    • Standard

      This driver is newer than the one above.

      Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;
      Pwd
      =myPassword;
      AS/400
    • 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;
      AS/400
  • .NET Framework Data Provider for ODBC

    • Use an ODBC driver from .NET

      Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

      See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

Articlesread all

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.