as400 database connection strings

Connection string examples when connecting to an as400, iseries, system i, os400, i5os

as400 JDBC connection string

jdbc:as400://mySystem;user=myUid;password=myPwd;

IBM DB2 for i .NET data provider

DataSource=myServerAddress;UserID=myUsername;Password=myPassword; DataCompression=True;

IBM Client Access OLE DB provider

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

.NET Framework Data Provider for OLE DB

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

Client Access ODBC driver

Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myPassword

iSeries Access ODBC driver

Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;Pwd=myPassword;

.NET Framework Data Provider for ODBC

Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUsername;Pwd=myPassword;

More as400 database connection strings to follow