Connection strings for AS/400 (IBM iSeries)
Providers for AS/400 (IBM iSeries)
Community Forums
Find solutions and post questions regarding connection string related issues.
IBM DB2 for i .NET data provider
Type
.NET Framework Class Library
Usage
Manufacturer IBM
Usage
Manufacturer IBM
Standard
DataSource=myServerAddress;UserID=myUsername;Password=myPassword; DataCompression=True;
IBM Client Access OLE DB provider
Type
OLE DB Provider
Usage Provider=IBMDA400
Manufacturer IBM
Usage Provider=IBMDA400
Manufacturer IBM
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
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.
.NET Framework Data Provider for OLE DB
Type
.NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to IBM Client Access OLE DB provider
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;Password=myPassword;
IBM Client Access ODBC driver
Type
ODBC Driver
Usage Driver={Client Access ODBC Driver (32-bit)}
Manufacturer IBM
Usage Driver={Client Access ODBC Driver (32-bit)}
Manufacturer IBM
Standard
Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myPassword;
IBM iSeries Access ODBC driver
Type
ODBC Driver
Usage Driver={iSeries Access ODBC Driver}
Manufacturer IBM
Usage Driver={iSeries Access ODBC Driver}
Manufacturer IBM
Standard
This driver is newer than the one above.
Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;Pwd=myPassword;
.NET Framework Data Provider for ODBC
Type
.NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Bridging to IBM Client Access ODBC driver
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.
Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myPassword;
Selected Articles