Specifying cellection using IBMDA400
Connection string
This IBM Client Access OLE DB provider connection string can be used for connections to AS/400.
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.