Connection strings for AS/400 (IBM iSeries)
Providers to use when connecting to AS/400 (IBM iSeries)
» IBM DB2 for i .NET data provider
» IBM Client Access OLE DB provider
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» IBM Client Access ODBC driver
» IBM iSeries Access ODBC driver
» .NET Framework Data Provider for ODBC (OdbcConnection)
» IBM Client Access OLE DB provider
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» IBM Client Access ODBC driver
» IBM iSeries Access ODBC driver
» .NET Framework Data Provider for ODBC (OdbcConnection)
Finding this site useful?
-Say "Thanks" to Andrew Morton and the other contributing developers!
-Thank you! »
-Say "Thanks" to Andrew Morton and the other contributing developers!
-Thank you! »
IBM DB2 for i .NET data provider
Standard
DataSource=myServerAddress;UserID=myUsername;Password=myPassword; DataCompression=True;
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
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
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
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)}
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}
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;
Loading ad...
.NET Framework Data Provider for ODBC
Type: .NET Framework Wrapper Class Library
Usage: System.Data.Odbc.OdbcConnection
Usage: System.Data.Odbc.OdbcConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
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;