Monday, May 18, 2009

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

No comments:

Post a Comment