AS/400 Connection strings - Connectionstring Examples

Connection strings Examples for AS/400 (IBM iSeries)

IBM DB2 for i .NET data provider

This is a .NET Class Library from IBM. The namespace for this library is IBM.Data.DB2.

You can read more about ADO.NET Development from IBM

Standard Security:

DataSource=yourServerAddress;UserID=yourUsername;Password=yourPassword; DataCompression=True;

This is a wrapping class from IBM.

IBM Client Access OLE DB provider

This is an OLE DB Provider from IBM. The usage for this provider is Provider=IBMDA400.

Standard Security:

Provider=IBMDA400;Data Source=YOUR_SYSTEM_NAME;User Id=yourUsername;Password=yourPassword;

Specifying cellection:

Provider=IBMDA400;Data Source=YOUR_SYSTEM_NAME;User Id=yourUsername;Password=yourPassword;Default Collection=YOUR_LIBRARY;

YOUR_SYSTEM_NAME = System Connection's name
YOUR_LIBRARY = Library in iSeries Navigator

.NET Framework Data Provider for OLE DB

This is a .NET class library from Microsoft. The namespace for this library is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=IBMDA400;Data Source=YOUR_SYSTEM_NAME;User Id=yourUsername;Password=yourPassword;

IBM Client Access ODBC driver

This is an ODBC driver from IBM. The usage for this library is Driver={Client Access ODBC Driver (32-bit)}

Standard Security:

Driver={Client Access ODBC Driver (32-bit)};System=YOUR_SYSTEM_NAME;Uid=yourUsername;Pwd=yourPassword;

IBM iSeries Access ODBC driver

This is an ODBC driver from IBM. The usage for this provider is Driver={iSeries Access ODBC Driver} .

Standard Security:

Driver={iSeries Access ODBC Driver};System=YOUR_SYSTEM_NAME;Uid=yourUsername;Pwd=yourPassword;